MySQL Forums
Forum List  »  InnoDB

Restore InnoDB schema from partial backup
Posted by: alena ss
Date: August 27, 2012 05:45AM

We had a server wipe-out by a virus (most likely someone ran it intentionally).
There was mysql 5.0.22 server running, but backups were not set for it.
We have windows backups, which contain ibdata1, ib_logfile0, ib_logfile1, but we do not have *.frm files in that backup.

So I tried to do this:
1. Installed latest version of mysql 5.5.27
2. Created all the tables from script files, but without any data - this created all the *.frm files
3. Copied ibdata1, ib_logfile0, ib_logfile1 from backup to mysql\data folder
4. Set innodb_force_recovery = 6 and tried to do a dump of a schema.
5. MySQL server crashes.

So I guess that somehow *.frm files relate to ibdata1 file and it is not possible to just recreate *.frm and match it with an old ibdata1 file.
Or maybe it is because I installed newer version of mysql server and that expects different ibdata1 format?
Or maybe because windows backup of ibdata1 and ib_logfileX would not really match?

Does anyone know for sure if it is possible to restore data in this situation?

Options: ReplyQuote

Written By
Restore InnoDB schema from partial backup
August 27, 2012 05: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.