mysqldump error: Table doesn’t exist status: Operation failed – Solution

images (3)

When running mysqldump to back up a database, you get this error:

This error can be for any number of reasons. I’ve ran into this because /var was 80+% full (very, very horrible situation). While clearing /var is pretty easy (if you’re brave, run this command: for i in find /var/log -type f -iname .log; do rm -rf $i; done), it won’t always be that easy. The real tricky part is when you get this error on a table or database you thought you already deleted. Welcome, this article.

Error Checking
To make sure that the table does exist and there’s no issues, you can run mysqlcheck:


This will check and repair any database and tables fed to it. However, if you receive something like:

There’s one quick way to resolve this, as this usually deals w/ a corrupt database or table, and if you don’t have a previous (working) backup then you’ll not be able to get around it any other way besides restructuring and re-entering the data. What you do now is simply delete the table by doing this:

Leave a Reply

Your email address will not be published. Required fields are marked *