I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find the backup I once made) the ibdata1 file is not the right one so the only thing I have to eventually restore the database are.frm and .idb (yes, I really, really screwed up) :

enter image description here

So, there seem to be some data left.

However, here is what I get in phpMyAdmin:

enter image description here

It says my tables don't exist (no table were found for wp_db). Is there any way I can restore the database?

  • What is the MySQL version? – dartonw Jun 30 '14 at 5:25

In general, if you're using MyISAM tables, you might be okay. See https://stackoverflow.com/a/879268/2385479 for instance.

If your tables are InnoDB, then it's a bit more difficult. According to https://serverfault.com/a/487534/67211, it seems the ibdata1 file is rather important.

Based on the error message, what I believe is happening here is that your database structure is being read correctly from the files you were able to recover, but the underlying table structure and associated data itself is in the missing file.

If it's a MyISAM table type, you can attempt to recover it (in phpMyAdmin click the Operations tab and look for the Repair text; from the command line or SQL tab just type REPAIR TABLE wp_commentmeta;.

Sorry for the bad news, but it doesn't look good.

|improve this answer|||||
  • .ibd means the tables are InnoDB. – ypercubeᵀᴹ Aug 10 '14 at 20:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.