Myisamchk does not think my table is corrupt!
Background:
-Site has 8000 uniques per day, average of 300 online at once hammering the forums.
-POST table has over 350,000 entries
When doing a backup with mysqldump and then trying to re-import the data to a test server, I keep getting:
ERROR 1030 at line 207477: Got error 28 from table handler
And the import stops at the POST table. Suspecting that it may have a corruption, I run a quick CHECK then a more thorough Myisamcheck --extend-check. Both checks do not return any errors with the table.
I am hesitant to just repair this table because I don't know if I have a good backup of it or not. This table gets updates about once every few seconds as people post so I need to work with a very recent copy to avoid losing data. I don't want to repair without having a backup that I just made.
Please advise-- is my table actually corrupted? Should I repair? Thanks,
Overgrow
Background:
-Site has 8000 uniques per day, average of 300 online at once hammering the forums.
-POST table has over 350,000 entries
When doing a backup with mysqldump and then trying to re-import the data to a test server, I keep getting:
ERROR 1030 at line 207477: Got error 28 from table handler
And the import stops at the POST table. Suspecting that it may have a corruption, I run a quick CHECK then a more thorough Myisamcheck --extend-check. Both checks do not return any errors with the table.
I am hesitant to just repair this table because I don't know if I have a good backup of it or not. This table gets updates about once every few seconds as people post so I need to work with a very recent copy to avoid losing data. I don't want to repair without having a backup that I just made.
Please advise-- is my table actually corrupted? Should I repair? Thanks,
Overgrow
