We have a backup system at the moment, but after a recent scare, we’d like another backup of just the MySQL databases, nightly, to a local server in our office.
The databases are pretty big as it stores a lot of different ecommerce stores. To make things easier for us to find them, rather than just get one giant SQL file, a file of each database would be ideal.
- The web server is CentOS with PHP/MySQL, with access via FTP/SSH
- The local server is Ubuntu with PHP/MySQL, with access via SSH
- Both servers have dedicated IP addresses
- Only the previous day’s database needs to be kept, so it can be overwritten upon success
Any suggestions on the best way to do this?