Desperate mysqldump, getting error error #1016, can't open *.ibd file

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

So we have a MySQL database that suddenly started reporting "can't
open *.ibd file" errors on InnoDB tables in phpMyAdmin.  (MyISAM are
fine).  To recover the data is all I want at this point -- so one
suggestion I came across was to try and dump using mysqldump like

mysqldump -u root -p mydatabase > databasedump.sql
Enter password: *******************
mysqldump: Got error: 1016: Can't open file: 'access.ibd' (errno: 1)
when using

Is there a way to run this dump so that it will export the database
tables and ignore the *.ibd error?  I had read that removing *.frm
files might help, but our testing suggests that it isn't effective

Any help will result in hero status. :-)  Holiday card list and all
those good karma things.



Site Timeline