MySQL table is marked as crashed and last (automatic?) repair failed

mysql repair
CryptoMiningPoolSetupYiimp picture CryptoMiningPoolSetupYiimp · Jan 13, 2012 · Viewed 172.7k times · Source

I was repairing this table suddenly server hanged and when I returned back all tables are ok but this one showing 'in use' and when I try to repair it doesn't proceed.

ERROR 144 - Table './extas_d47727/xzclf_ads' is marked as crashed and last (automatic?) repair failed

What can I do to repair it?

Answer

Aleksandar Vucetic picture Aleksandar Vucetic · Jan 13, 2012

If your MySQL process is running, stop it. On Debian:

sudo service mysql stop

Go to your data folder. On Debian:

cd /var/lib/mysql/$DATABASE_NAME

Try running:

myisamchk -r $TABLE_NAME

If that doesn't work, you can try:

myisamchk -r -v -f $TABLE_NAME

You can start your MySQL server again. On Debian:

sudo service mysql start

Related questions

How do I repair an InnoDB table?

We (apparently) had poorly executed of our Solaris MySQL database engine last night. At least some of the InnoDB tables are corrupted, with timestamp out of order errors in the transaction log, and a specific error about the index being …

Read More
How to repair a MySQL table without using phpMyAdmin?

I had a table with complicated columns, I started to fill it with a heavy data, during that, it crashed. table reported as crashed and need to be repaired. Repair Table in phpmyadmin could not repair it. Then I decided …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More