MySQL: table is marked as crashed
Posted
by DrStalker
on Server Fault
See other posts from Server Fault
or by DrStalker
Published on 2010-05-03T06:40:32Z
Indexed on
2010/05/03
6:48 UTC
Read the original article
Hit count: 300
mysql
After a disk full issue one of the MySQL DBs on the server is coming up with the following error when I try to back it up:
[root@mybox ~]# mysqldump -p --result-file=/tmp/dbbackup.sql --database myDBname
Enter password:
mysqldump: Got error: 145: Table './myDBname/myTable1' is marked as crashed and should be repaired when using LOCK TABLES
A bit of investigation shows two tables have this issue.
What needs to be done to fix up the damaged tables?
© Server Fault or respective owner