Simple mySQL backup script for cron

fak3r (fak3r) — Wed, 20 Jun 2007 15:01:39 GMT

Simple mySQL backup script for cron - backs up all databases, saves the last 4 copies.



#!/bin/bash



# modify the following to suit your environment

export DB_BACKUP="/backup/mysql_backup"

export DB_USER="root"

export DB_PASSWD="********"



# title and version

echo ""

echo "mySQL_backup"

echo "----------------------"

echo "* Rotating backups..."

rm -rf $DB_BACKUP/04

mv $DB_BACKUP/03 $DB_BACKUP/04

mv $DB_BACKUP/02 $DB_BACKUP/03

mv $DB_BACKUP/01 $DB_BACKUP/02

mkdir $DB_BACKUP/01 



echo "* Creating new backup..."

mysqldump --user=$DB_USER --password=$DB_PASSWD --all-databases | bzip2 > $DB_BACKUP/01/mysql-`date +%Y-%m-%d`.bz2

echo "----------------------"

echo "Done"

exit 0

DZone Snippets: cron code

Simple mySQL backup script for cron