Dette lille script dumper alle MySQL Databaser, og holder et par versioner standby, for let restore:
#!/bin/sh FIND=/usr/bin/find GZIP=/bin/gzip MYDUMP=/usr/bin/mysqldump # find all databases and export them for i in `(cd /var/lib/mysql/; ${FIND} * -type d -user mysql) 2>/dev/null`; do # if old file exists, delete it if [ -f /backup/mysqlbackup/$i.sql.gz.2 ]; then mv /backup/mysqlbackup/$i.sql.gz.2 /backup/mysqlbackup/$i.sql.gz.3 fi if [ -f /backup/mysqlbackup/$i.sql.gz.1 ]; then mv /backup/mysqlbackup/$i.sql.gz.1 /backup/mysqlbackup/$i.sql.gz.2 fi if [ -f /backup/mysqlbackup/$i.sql.gz ]; then mv /backup/mysqlbackup/$i.sql.gz /backup/mysqlbackup/$i.sql.gz.1 fi # dump current database ${MYDUMP} --lock-tables --user=root --password=****** --databases $i | $GZIP > /backup/mysqlbackup/$i.sql.gz done