How to restore dates from ibdata1 and old dump.
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.
Subject
Views
Written By
Posted
How to restore dates from ibdata1 and old dump.
6345
October 21, 2012 05:52AM
2990
October 22, 2012 03:21AM
2387
October 28, 2012 03:04AM
2888
October 28, 2012 09:40PM
2246
November 08, 2012 12:19AM
1935
November 18, 2012 10:30PM
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.