: Best Automatic Backup Solution Options? I have a VPS with WiredTree.com in which I have access to WHM. I'm looking for a good backup solution where I can do the following things Backups both

@Correia994

Backups should always be on another server.

You can use rsync for your files, and mysqldump your for mysql databases.

I run a backup via cron, just using tar, mysqldump and SSHFS. This is a very simple solution, but works for me. Here my code (all in the root crontab).

MAILTO=crontab@website.com
#Mysql daily
30 4 2,4,6,8,10,12,14,16,18,20,22,24,26,28,30 * * /usr/bin/mysqldump --user=root --password=passwd --opt --all-databases | gzip -2 > /root/backups/even/all.gz
30 4 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31 * * /usr/bin/mysqldump --user=root --password=passwd --opt --all-databases | gzip -2 > /root/backups/odd/all.gz
#Files Daily
0 2 2,4,6,8,10,12,14,16,18,20,22,24,26,28,30 * * tar cf /root/backups/even/etc.tar /etc/ /var/spool/cron/ /usr/local/sim
0 2 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31 * * tar cf /root/backups/odd/etc.tar /etc/ /var/spool/cron/ /usr/local/sim
15 2 2,4,6,8,10,12,14,16,18,20,22,24,26,28,30 * * tar cf /root/backups/even/home.tar /home/
15 2 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31 * * tar cf /root/backups/odd/home.tar /home/

# Weekly
0 6 7,21 * * rm -f /root/backups/week/* && cp /root/backups/odd/* /root/backups/week/
0 6 14,28 * * rm -f /root/backups/week/* && cp /root/backups/even/* /root/backups/week/

0 1 * * * unmount /root/backups
1 0 * * * /usr/bin/sshfs -o idmap=user -p 22 backups@server.com:/home/backups /root/backups > /dev/null

Vote Up Vote Down