Re: MySQL ibdata1 is lost in server
Restore ibdata1 from a backup. If there's no backup, ask a tech shop to try to recover the file. If that's impossible, and if there's no ibdata2 file either, the data that was in ibdata1 is lost. The .frm files contain table defs only.
And institute regular backups.
Subject
Views
Written By
Posted
1758
October 22, 2015 05:54AM
Re: MySQL ibdata1 is lost in server
783
October 22, 2015 09:51AM
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.