enginbayar Posted July 27, 2015 Share Posted July 27, 2015 How can a read only MYISAM table become corrupt? I have to do a myisamchk -r approx. once a week as the table gets marked as crashed. I can't see how this is happening though as no changes are being made to it, it's read only. It's running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so far. Link to comment Share on other sites More sharing options...
submix8c Posted July 27, 2015 Share Posted July 27, 2015 HDD error? Link to comment Share on other sites More sharing options...
Tripredacus Posted July 27, 2015 Share Posted July 27, 2015 HDD error? While it is a valid question, this is likely to be a trap topic for spambots to reply in. First post is a copy/paste of a post on another forum where that has occurred, you can find it with these google terms: "corrupt read only tables" calebbaxter Link to comment Share on other sites More sharing options...
Yzöwl Posted July 27, 2015 Share Posted July 27, 2015 This topic has been moved from the Programming Forum area These tables are normally stored in three files, the definition, data and index, and are very easily corrupted. The usual advice is to jump ship to an alternative such as InnoDB. Link to comment Share on other sites More sharing options...
Guest jonahwatkins Posted July 28, 2015 Share Posted July 28, 2015 The recovery plan is following Split corrupted InnoDB tablespace into pages; sort the pages by type and index_idFetch records from PRIMARY index of the tableDROP corrupted table and create new oneLoad records back into MySQL Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now