mysqldump error: Table doesn’t exist status: Operation failed – Solution
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.
To make sure that the table does exist and there’s no issues, you can run mysqlcheck:
mysqlcheck -u mysql_username -p database_name
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: