Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've used myhotcopy to backup my MySQL databases. I had to recovery everything after a system crash, so I moved the files into the MySQL directory.

Now, every 1-2h the server seems to do an auto repair for some tables or anything like this. If I manually start a repair, the table will be marked as crashed after that.

Anyone knows, why this happens and how I can fix this?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

I would mysqldump everything, move the db and innodb files somewhere safe, and reload from the dumps. Will likely take less time..

Could the mysqlhotcopy job the files originate from ever have run out of file descriptors/driven mysqld out of the same while dumping unattended? That is an extremely great way to get a subtly corrupt backup, mostly working, of a mysql installation. Mysqldump is similarly vulnerable by the way; any spurious errors when dumping should never be ignored as they often point to exactly that problem.

share|improve this answer
    
Dumped the whole DB and inserted it again. I'll let it run for a few hours and give you feedback then. –  Sn0opy May 6 '12 at 17:24
    
Both tables, which were marked as crashed before, are looking good for hours now. Thanks for the tip. –  Sn0opy May 7 '12 at 7:04
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.