Backing up my VPS with Rsync. What about MySQL and server settings?

Server Config
1

I’m just getting to grips with my first VPS and enjoying the challenge!

I have 20Gb of Rsync backup space from the host with an internal IP and have just setup my SSH key and managed to sucessfully backup the /home/ directory.

However I have just realised that this will not be including the MySQL databases on the accounts. So what is the easiest way to backup these in 1 go? (I have found the script - auto mysql backup.)

Also what other directories should I backup for settings etc - Another post mentioned the etc/ directory?

Also is this sufficient for backing up, I’m guessing I should be backing up to myself?

2

The best way to manage backups is to keep it simple and of course automated.

Use cron to rsync your home / web root / mysql dumps / and any highly customised files in /etc/ such as httpd.conf

Mysql database dump can be performed in a number of ways (mysqldump).

That is usually all you will need, then it is a good idea to be familiar with a server rebuild so that you can quickly get a new build up and running, restore your databases and files. Alternatively if this is unknown territory have a contact number for someone who can do this for you.