MySQL Forums
Forum List  »  Data Recovery

Recover database from idbata1 after all frm files dissapeared
Posted by: Pablo García
Date: December 03, 2011 11:34PM

Hi,

i don't find the solution for my problem, i hope you can say me "it's possible" and how...

My MySQL instance crashed because of free disk space fault. I saw in /var/lib/mysql all the files: ibdata1, ib_logfile* and all the folders containing frm files. Well, when i solved the problem and runned successfully the instance, some databases dissapeared. One of those is the most important, and i don't know how many tables had and their structures. Is there any way for recover the entire lost database (structure and data) only having the ibdata1 file?

Thanks a lot!

Options: ReplyQuote


Subject
Views
Written By
Posted
Recover database from idbata1 after all frm files dissapeared
4329
December 03, 2011 11:34PM


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.