470,620 Members | 1,413 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,620 developers. It's quick & easy.

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

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

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

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
either.

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

thanks!!

Chuck

Jul 17 '07 #1
0 3664

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Sagar, Sanjeev | last post: by
8 posts views Thread by Irvin Amoraal | last post: by
7 posts views Thread by Adam Smith | last post: by
reply views Thread by Adam Smith | last post: by
3 posts views Thread by Christopher Mouton | last post: by
6 posts views Thread by Peter Frost | last post: by
6 posts views Thread by Robert Blackwell | last post: by
2 posts views Thread by dev2746 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.