MySQL Forums
Forum List  »  InnoDB

Re: MySQL ibdata1 is lost in server
Posted by: Peter Brawley
Date: October 22, 2015 09:51AM

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.

Options: ReplyQuote


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.