|
Look for a bare metal recovery type solution but with a MySQL database that most likely is changing all the time, you need to setup some type of daily incremental or dumps of that database. With that, you should use something like MySQL-ZRM or at minimal do a mysqldump hourly, daily.. etc, depending on how valuable the data is, how often it changes, etc.
You can just backup the /var/lib/mysql files to backup the database but imagine if you backed up while data was being written and took you backup right in the middle, this could cause problems.
|