This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
rsync-backup [2013/07/10 09:58] zoza old revision restored |
rsync-backup [2014/01/03 10:08] zoza [manual backup] |
||
---|---|---|---|
Line 23: | Line 23: | ||
<code>rsync -azvv /var/lib/mysql /somewhere</code> | <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 ====== | ====== automated backup ====== | ||