|  | 9 |  | 
                          |  | 10 | == Backups == | 
                          |  | 11 |  | 
                          |  | 12 | === Mysql === | 
                          |  | 13 |  | 
                          |  | 14 | The gaia script for backing up the Mysql databases is /root/sbin/mysql_backup_daily.sh and it contains: | 
                          |  | 15 |  | 
                          |  | 16 | {{{ | 
                          |  | 17 | #!/bin/sh | 
                          |  | 18 | BACKUP=/var/backups/mysql_backup.`date +%a`.sql.gz | 
                          |  | 19 | /usr/local/bin/mysqldump -h localhost -u root -pXXX --all-databases | /usr/bin/gzip -c > $BACKUP | 
                          |  | 20 |  | 
                          |  | 21 | # backup to the development server, kiwi.webarch.net see ~/.ssh/config | 
                          |  | 22 | scp $BACKUP kiwi:new-live-data/var/backups/ | 
                          |  | 23 | }}} | 
                          |  | 24 |  | 
                          |  | 25 | And /root/.ssh/config contains: | 
                          |  | 26 |  | 
                          |  | 27 | {{{ | 
                          |  | 28 | Host kiwi | 
                          |  | 29 | User live | 
                          |  | 30 | Hostname kiwi.webarch.net | 
                          |  | 31 | }}} | 
                          |  | 32 |  | 
                          |  | 33 | And the backups are written to /home/live/new-live-data/var/backups on wiki.webarch.net | 
                          |  | 34 |  |