My website has crashed a few days ago.

The hosting company says some innodb database crashed.

They sent a MySql data folder. I tried to restore the database, but phpmyadmin is only showing MyISAM tables.

I checked the database with navicat. When I click innodb table, I got this error table 'xyz.wp_posts' doesn't exist.

is there anyway to fix this on windows?

Feel free to download db:


Very old backup:


  • Do you have the ibdata1 file in there as well? Are there any errors in the error logs when you start MySQL up? – Ladadadada Jun 15 '12 at 6:13
  • no. i dont have a ibdata1 .120615 23:01:08 [ERROR] Cannot find or open table deganalizbozuk/wp_links from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. See dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html how you can resolve the problem. – mr heLL Jun 15 '12 at 20:01
  • you should have ibdata1 file... otherwise very hard problem... try to search articles about recovering without ibdata1... – T.Todua Dec 3 '15 at 23:29
  • On Stackoverflow you might find this answer: stackoverflow.com/questions/25100621/… – T.Todua Dec 3 '15 at 23:37
  • Here is a great topic on StackExchange - dba.stackexchange.com/questions/16875/… – T.Todua Dec 3 '15 at 23:38

There are settings in my.cnf that can be set to allow innodb to try to recover it's own tables[1]. These might be able to get you part of the way.If this does not help you, you have to get your hands dirty. I have used the percona recovery tools[2] a few times, with great success. Documented here[3]

And it might be a bad idea for you to share your databases with the internet. It can be very unforgiving.

[1] http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html

[2] https://launchpad.net/percona-data-recovery-tool-for-innodb

[3] http://www.percona.com/docs/wiki/innodb-data-recovery-tool:start

  • i cant try percona. i dont have a linux. if i can't save the data dont important security :) – mr heLL Jun 15 '12 at 20:24

I've managed to recover from a crash I've had on one of my cpanel servers. If anyone else is reaching this let state that this forum post (cpanel) helped me. However, the script was old (2008) and was not working anymore. I've fixed and posted back to here, thinking someone might need it like I did. Simply download this instead of the one specified in that forum post.

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.