Differences

This shows you the differences between two versions of the page.

--- rsync-backup [2012/12/21 15:31]
85.218.109.130
+++ rsync-backup [2014/01/03 10:08] (current)
zoza [manual backup]
@@ Line 2: / Line 2: @@
 (run as sudo)
+ - local backup
 <code>rsync -azvv  --exclude /var/log /etc /home /opt /var  /pathtofolderwherebackupisstored</code>
+ - remote backup
+<code>rsync -azvv -e ssh /foldertobackup remoteuser@remotehost.remotedomain:/wheretostorebackup
 https://help.ubuntu.com/community/rsync
@@ Line 17: / Line 23: @@
 <code>rsync -azvv /var/lib/mysql /somewhere</code>
+ - backup the database(s)
+<code>mysqldump -u root -ptmppassword --all-databases > /tmp/all-database.sql</code>
+source {{http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/|here}}
 ====== automated backup ======
+(as sudo) run crontab:
+<code>crontab -e</code>
+edit the file, so that cronjob will run the command each 1st of the month, at 20:45
+<code>45 20 1 * *  rsync -azvv  --exclude /var/log /etc /home /opt /var  /srv/mis_duplicate/backingup</code>
+and backup the server (only folders /etc, /home, /opt, /var) to an external disk
+> cron format: http://www.nncron.ru/help/EN/working/cron-format.htm
+more:
 http://rbgeek.wordpress.com/2012/05/22/automatic-backup-from-ubuntu-server-with-rsync/

emperor's new architecture research