I didn't forget I haven't set up a backup system for this blog site. So I got it done today.
Two things need to backup, they are
- the MySQL database
- the
uploads
directory that contains the pictures, files you've uploaded to this site
Since local backup is not safe, finally I chose the Yandex.Disk as my cloud storage. Just register an account in 5 minutes and you will get 10G cloud storage with Linux friendly sync feature.
Yandex.Disk also supports symbol links, that's quite good.
run crontab -e
and fill in below lines, the setting was done!
15 3 * * * mysqldump --databases blog | gzip > /home/zhongwei/Yandex.Disk/backups/mysql/blog_`date '+\%Y\%m\%d-\%H\%M\%S'`.sql.gz
20 3 * * * find /home/zhongwei/Yandex.Disk/backups/mysql/blog* -mtime +30 -exec rm {} \;
As the uploads folder for my blog, what you need to do is creating a symbol link to the Yandex.Disk folder:
ln -s /www/blog/uploads /home/zhongwei/Yandex.Disk/backups/blog_uploads
This blog is inspired by source