1

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?

1
  • What is the MySQL version?
    – dartonw
    Jun 30, 2014 at 5:25

1 Answer 1

2

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.

1
  • .ibd means the tables are InnoDB. Aug 10, 2014 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.