Backup of a mysql database which is not running anymore

Question

Hi,

after a system failure, I have only limited access to the server. Question is, where does msyql store the database(s) and is it enough to just copy the files, or is anything else needed?

I think I already spotted the databases @ /var/lib/mysql ... is it enough to backup these files & re-use them with a newly created database?

Answer 1

Maybe, it depends on your table type.

Check this tutorial out. It goes over different ways to get your database backups and also discusses methods on backing up for the future if you ever have this problem again.