List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 16 2010 10:15am
Subject:Re: how to recover crashed db: only the db or the whole directory /var/lib/mysql
View as plain text  
It depends on what u want to recover and type of the db engine...

If u want to recover just the specifi db and if u have dump of the db, just
restore the db for innodb.

for myisam, u can just restore the files in that database.

regards
anandkl

On Thu, Sep 16, 2010 at 3:27 PM, Uwe Brauer <oub@stripped> wrote:

> Hello
>
> I have so far tried (unsuccessfully) to recover the database
> from the crashed Mac. (I am using Kubuntu 9.04)
>
> I tried 2 tactics.
>
>    -  shutdown the server (service mysql shutdown)
>       copy the maqwiki folder into /var/lib/mysql
>       restart the server. The server came up some tables
>       show their content.
>
>    -  shutdown the server
>       replace the whole myslq directory which in the case
>       of the Mac is somewhere in /Application/MAMP/db/mysql
>       or something like this
>       to /var/lib/mysql
>       then the server did not come up. I looked for a log
>       file, for example in /var/log, but the mysql.log is
>       empty and the syslog does not show anything with
>       respect  to mysql.
>
> Any ideas
>
> Thanks
>
> Uwe Brauer
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
how to recover crashed db: only the db or the whole directory /var/lib/mysqlUwe Brauer16 Sep
  • Re: how to recover crashed db: only the db or the whole directory /var/lib/mysqlAnanda Kumar16 Sep