MySQL Forums
Forum List  »  Data Recovery

How to restore dates from ibdata1 and old dump.
Posted by: Ruslan Valitov
Date: October 21, 2012 05:52AM

Today I reinstalled my Wondows Server 2008 OS, but forgot about MySQL 5.5, so I lost my datas. My InnoDB data base folder was located on D: drive, so I have ibdata1 file, and old dump of data base. How can I restore my lost database?
I tried reinstall mySQL 5.5 on virtual machine, then i load old data base from dump. After that i stoped mySQL server and replace ibdata1 file, in my.ini I typed innodb_force_recovery=1 but no result, then innodb_force_recovery=2..6. But no lost datas in old database that I load from old dump.
How can I restor my dates? Can anyone help me?
Thank you all, regards Ruslan.

Options: ReplyQuote

Written By
How to restore dates from ibdata1 and old dump.
October 21, 2012 05:52AM

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.