ibdata1 corrupt, how recover innodb file-per-table?
I have a server where the hard disk has failed, right on the ibdata1 file. Of course it turns out the backup has failed, the latest full backup is old :-|
However, I am pretty sure the database structure has changed since last backup and I can copy all the innodb file-per-table files.
What do you think of this recovery attempt;
- Clean install of MySQL
- Restore with latest backup
- Stop MySQL
- Copy back the innodb file-per-table files
Any chance this may work? Better suggestion?
(Yes, I will make sure there are proper backups next time)
Subject
Views
Written By
Posted
ibdata1 corrupt, how recover innodb file-per-table?
3813
January 25, 2014 07:42AM
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.