Re: Lost Schema but still have the data - rebuild?
Posted by:
Max 39
Date: October 23, 2007 09:09AM
Some more questions:
Is the server still running? If so can you connect to it and access the mysql database ( use mysql)?
What version?
If you can connect, run "select @@datadir" Under here, you should see a subdirectory with the same name as the "schema" that you lost. If it is not there, then I suspect you accidentally deleted it, or the permissions are unsufficient.
You can try to "mkdir" that schema in the "datadir" and then copy the frm, myi, myd files there.
Subject
Written By
Posted
Re: Lost Schema but still have the data - rebuild?
October 23, 2007 09:09AM
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.