posted by admin
on Wed, 07/02/2014 - 10:36
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.
Comments
Add new comment