Broken database?

Author Message

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?

regards
lukasz

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.