how to recover crashed db: only the db or the whole directory /var/lib/mysql

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=gcdmg-mysql-2@m.gmane.org

Re: how to recover crashed db: only the db or the whole directory /var/lib/mysql

--0016367b5dbc8bd38204905db823
Content-Type: text/plain; charset=ISO-8859-1

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 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=anandkl@gmail.com
>
>

--0016367b5dbc8bd38204905db823--