enginbayar Posted July 27, 2015 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.
Tripredacus Posted July 27, 2015 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
Yzöwl Posted July 27, 2015 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.
Guest jonahwatkins Posted July 28, 2015 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
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