Skip to content

Instantly share code, notes, and snippets.

@zarza

zarza/gist:75b907583ecef3c46531

Last active March 15, 2016 01:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zarza/75b907583ecef3c46531 to your computer and use it in GitHub Desktop.
Save zarza/75b907583ecef3c46531 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL error: Table './..../postparsed' is marked as crashed and Should be repaired
Raw
gistfile1.sql
#Try 'REPAIR TABLE postparsed;' first.
DROP TABLE `postparsed`;
CREATE TABLE IF NOT EXISTS `postparsed` (
`Postid` int (10) unsigned NOT NULL default '0',
`Dateline` int (10) unsigned NOT NULL default '0',
`Styleid` smallint (5) unsigned NOT NULL default '0',
`Languageid` smallint (5) unsigned NOT NULL default '0',
`Hasimages` smallint (6) NOT NULL default '0',
`Pagetext_html` medium text,
PRIMARY KEY ( `postid`,` styleid`, `languageid`)
KEY `dateline` (` dateline`)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment