MySQL Forums
Forum List  »  InnoDB

MySQL ibdata1 is lost in server
Posted by: Angel Rivero
Date: October 22, 2015 05:54AM

Hi there, hope in your help.

The database MySQL version 5.5.35 has suffered critic crash on windows server 2003.

Now the file ibdata1 is lost; before the crash the size of ibdata1 was 5GB.

I have restarted the Windows server.

I have stopped and restarted the MySQL service and is created a new ibdata1 file but all InnoDB tables doesn't exists.

In the folder of my Db I have the table Innodb file with .frm extension.

I have tried this tutorial without success. How to recover an orphan InnoDB database from .ibd file
http://www.ipserverone.info/database/how-to-recover-an-orphan-innodb-database-from-ibd-file/

Please help me.

Thank you in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL ibdata1 is lost in server
1757
October 22, 2015 05:54AM
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.