RSS twitter

Posts tagged ‘script’

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"`/