Codebreaker 2bc08752a0894eb2c7afb345286e391d

Automated MySQL Backup Script

Please leave a comment if you have any suggestions or questions.

#!/bin/bash
#
# Automated MySQL backup script
#
# @author Sumin Byeon
# @since 20070815
# @version 20070927

dir="mysql"
databases=( db1 db2 db3 ... )

# The user must be an existing MySQL user with proper preveliges
user="backup"
password="your password"

for db in ${databases[@]}; do
    timestamp=$(date +%Y%m%d%H%M%S)
    filename=$dir/$db-$timestamp

    mysqldump $db -u $user -p$password > $filename.sql
    chmod 600 $filename.sql

    tar jcf $filename.tar.bz2 $filename.sql
    chmod 600 $filename.tar.bz2

    rm $filename.sql
done