RSS twitter

Bash Mysql backup script

#!/bin/sh

HOST="domain.com"
USER="username"
PASS="password"
HOME="/home/username"

mkdir $HOME/backup/databases/`date +"%d%b"`
mysqldump -h $HOST -u $USER --password=$PASS MailServer > $HOME/backup/databases/MailServer`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS domain_ads  > $HOME/backup/databases/domain_ads`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS domain_easyb >  $HOME/backup/databases/domain_easyb`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS crm > $HOME/backup/databases/crm`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS forum_domain > $HOME/backup/databases/forum_domain`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS games > $HOME/backup/databases/games`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS livesupport > $HOME/backup/databases/livesupport`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS domain_org > $HOME/backup/databases/domain_org`date +"%d%b"`.sql
mysqldump -h $HOST -u $USER --password=$PASS mysql > $HOME/backup/databases/mysql`date +"%d%b"`.sql
cd $HOME/backup/databases/
bzip2 *.sql
mv *.bz2 $HOME/backup/databases/`date +"%d%b"`/

2 Comments

  1. telo says:

    is this script hourly or daily auto backup my database?

  2. mandea says:

    @telo: This is a daily backup script; You can make a list with your databases for what you need backup:

    MYDBS=”database1 database2 database3 myotherdb”
    for i in $MYDBS;do mysqldump -h $HOST -u $USER –password=$PASS > $HOME/backup/databases/$i.sql;done

Leave a Reply