Our db server died several days ago. Long story short, we had to move the db directory to a new machine to recover the data. Some of the tables were innodb. Now, when I try to dump the db for backup, I get:
Code:
mysqldump -uroot -p -hlocalhost production > ~/production.`date +%F`.sql
Enter password:
mysqldump: Got error: 1146: Table 'production.accounts_user' doesn't exist when using LOCK TABLES
If I hop into mysql "production" db & show the tables, I see accounts_user in the list, but if I try to describe it, I get the "table doesn't exist" error.
I can't drop the table, or truncate it, or really do anything to it.
I don't care about the data in that particular table, but I would like to be able to backup the rest of this database. Any ideas?
edited to add:
Code:
mysql> check table accounts_user;
+---------------------------------------+-------+----------+-------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+-------+----------+-------------------------------------------------------------+
| production.accounts_user | check | error | Table 'production.accounts_user' doesn't exist |
+---------------------------------------+-------+----------+-------------------------------------------------------------+