MySQL Forums
Forum List  »  Data Recovery

Restore a crashed Innodb database from ibdata1 and frm files
Posted by: Julien Balmont
Date: February 06, 2010 06:45AM

Hi,

this morning it appears that one of my mysql servers crashed.
Most of the database seems now to be corrupted, as I can't access the datas anymore. Tables ar epresent, but empty.

I have a backup of ibdata1 file, and all the frm ones.

What can I do?
I've tried to do a mysqldump using
mysqldump -u root -p --all-databases > /tmp/dump.sql
But I get the following error, which corresponds to the first table it tries to dump.
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `synchro`': Incorrect key file for table 'synchro'; try to repair it (1034)

Can anybody help wuickly? This is a system on production, and I can't find a correct solution.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore a crashed Innodb database from ibdata1 and frm files
7296
February 06, 2010 06:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.