Forums / Install & configuration / Broken database?
Bjarne MAthiesen
Tuesday 22 January 2008 3:33:12 pm
My harddrive has been corrupted ;-(
And offcourse it is in the database files of my site, so now it says "no access"As far as I can see, it has lost some tables in the database regarding users.
Where can I find the sql that creates the database for mysql?
Isn't it possible to repair the database?
Please help me. A lot of work is lost if I dont get this back up.
Lukasz Klejnberg
Friday 25 January 2008 4:47:26 am
hi
if you can copy binary files from directory where is database mysql, like this:/var/lib/mysql/your_database
and
/var/lib/mysql/ibdata1 and ib_logfile0-...
to your new mysql directory.
It is the best if you do this operation on local machine, then if you run your database you must export to sql and import to your new database.
maybe you must try to find solutions to recovery ibdata1?
regardslukasz