December 19, 2010, 6:21 pm
#!/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"`/
is this script hourly or daily auto backup my database?
@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