Tag Archives: mysqldump

How do I Fix a Corrupt MySQL Table?

mysqldump Can’t open file: ‘tablename.MYD’. (errno: 145) This usually means the table has become corrupt. Most commonly this happens when the partition that contains your MySQL files is full, but I have had it happen at other times. Especially on … Continue reading

Posted in Database, MySQL, Server Administration Tagged , , , , ,

Database error fix… mysqldump: Couldn’t execute show create table view

Today I found that my automated MySQL backups have been choking for the last few days with “mysqldump: Couldn’t execute show create table view” because I recently added a view to one of the databases. Apparently the backup user needs … Continue reading

Posted in Code Snippets, Database, MySQL, Server Administration Tagged , , , , ,