How to completely backup all mysql databases?

What are the best ways to backup Debian-based VPS?

• What is the best way to backup all my stuff, including configs, mysql databases, etc., on a Debian-based VPS?

• Answer:

  Since you are only worried about a single server, enterprise-style applications such as BackupPC and Amanda are probably overkill. You would be better suited with something simpler. I'll list a few of the common tools, then give some possible solutions: rdiff-backup - http://www.nongnu.org/rdiff-backup/ unison - http://www.cis.upenn.edu/~bcpierce/unison/ duplicity - http://duplicity.nongnu.org/ rsync - Available in the repo's. Any of the above can be scripted in bash. However, unless you need something fancy or really simple, it's probably easiest to use a script already written: For rsync  - https://github.com/yhager/rsync_backup (I prefer this solution over rdiff-backup - see the author's README file for details) For MySQL - http://sourceforge.net/projects/automysqlbackup/ For file-level backup, not using rsync - http://simplebashbu.sourceforge.net Read over the tools at the top however and see if one of them would be a better fit for your scenario. When configuring your scripts, you just need to make sure you are backing up all of your important directories. Since you have a VPS and won't need to restore from your own custom image, you can leave some of those out. Here's what I would include: /etc /home /opt (if it's not empty) /root /srv /var You can either get another VPS to use for backup, or you can rent storage from the likes of http://rsync.net or tarsnap, to hold your backup files. You can set up SSHFS on your VPS to mount the remote filesystem so that the backup tools spool locally, and then need to set up a cron job to run whichever scripts you've chosen. http://Rsync.net has some good tutorials on how to do some of the above, and their service is rock-solid.