Backup of a mysql database which is not running anymore
after a system failure, I have only limited access to the server. Question is, where does msyql store the database(s) and is it eno开发者_开发问答ugh 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?
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.
精彩评论