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

Read Time:58 Second

Error
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:

Code:

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

Solution
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:

0 0
Happy
Happy
0 %
Sad
Sad
100 %
Excited
Excited
0 %
Sleppy
Sleppy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

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