MySQL Forums
Forum List  »  InnoDB

Recover innodb table!
Posted by: quang np
Date: August 15, 2008 01:11PM

My ibdata1 file is crashed. I used ddrecue to copy ibdata1 to another location. There is only 4096B/500MB is lost. (all log, frm myi and myd files is OK). But mysql can't start with recover ibdata1 file.
Is there any way to recover my database?

(I also have backup database some day before, can I merge data from old ibdata1 file to current?)



Edited 1 time(s). Last edit at 08/15/2008 01:11PM by quang np.

Options: ReplyQuote


Subject
Views
Written By
Posted
Recover innodb table!
2681
August 15, 2008 01:11PM


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.