[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?

[root@db 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.

Tags: 

Comments

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.