Lost Schema but still have the data - rebuild?
Posted by: Alan Barraclough
Date: October 20, 2007 09:18PM

Ive got a MySQL Database which i was happily using, and then suddenly it wouldnt connect, and the MySQL Administrator said the schema no longer existed. However the data still exists in MySQL\data.

I made a lot of changes since my last backup, and would like to avoid starting at my last backup point.

So how did it happen?

and even more importantly, how can I get the schema back based on the data files I still have. I have a set of text files ending in MDY, MYI and frm

Options: ReplyQuote

Written By
Lost Schema but still have the data - rebuild?
October 20, 2007 09:18PM

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.