1

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:

www.degisimanaliz.com/xyzdb.tar.gz

Very old backup:

www.degisimanaliz.com/29_Ocak_Yedek_deganaliz.sql.gz

Improve this question
5
  • 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, 2012 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, 2012 at 20:01
  • you should have ibdata1 file... otherwise very hard problem... try to search articles about recovering without ibdata1...
    – T.Todua
    Dec 3, 2015 at 23:29
  • On Stackoverflow you might find this answer: stackoverflow.com/questions/25100621/…
    – T.Todua
    Dec 3, 2015 at 23:37
  • Here is a great topic on StackExchange - dba.stackexchange.com/questions/16875/…
    – T.Todua
    Dec 3, 2015 at 23:38

2 Answers 2

Reset to default
1

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

Improve this answer
1
  • i cant try percona. i dont have a linux. if i can't save the data dont important security :)
    – mr heLL
    Jun 15, 2012 at 20:24
0

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .