How to Copy a MySQL account / databse

[winger]

hello,

we have a crashed server, some services are not running, like mysql

last backup that we have for a account, does not have the mysql files (probably mysql was already not running)

we can found the account files at /var/lib/mysql on the crashed server

can someone point us in how to move this to a new server?

thanks in advance!

 

[zEitEr]

Hello,

The whole /var/lib/mysql directory can be easily transfered between mysql servers of the same version.

If you copy /var/lib/mysql it might or not help to run MySQL. The things might be worse if InnoDB tables are crashed, or you've got other files missing or corrupted. So to restore all the tables you might still need to have backups.