[SOLVED] mysqldump: Can't get CREATE TABLE for table

Have you tried to make a backup of a MySQL database, and run into a problem with errors?

[[email protected] root]# mysqldump --all-databases >db.sql 
mysqldump: Can't get CREATE TABLE for table `nuke_stats_date` 
(Can't open file: 'nuke_stats_date.MYD'. (errno: 144)) 

I remember we had trouble with MySQL database when the disk filled to 100%, which we killed MySQL process manually. Since this happened, some of the database tables were corrupted and we were able to fix them using the 'repair' command. You may repair the corrupted MySQL database with the following commands:

Try the following:

mysql> repair table nuke_stats_date 

Or

bash# mysqlcheck --repair --extended --all-databases 

You may have to perform multiple runs to clean up the database.