Back

备份SQL数据库

|

一个备份本地数据库到远程FTP服务器的shell脚本.
`` #!/bin/bash
MYSQL_USER=
MYSQL_PASS=
FTP_USER=
FTP_PASS=
FTP_IP=
FTP_backup=
DataBakName=Data_$(date +"%Y%m%d").tar.gz
OldData=Data_$(date -d -3day +"%Y%m%d").tar.gz
rm -rf /home/backup/Data_$(date -d -3day +"%Y%m%d").tar.gz
cd /home/backup
for db in `/usr/local/mysql/bin/mysql -u$MYSQL_USER -p$MYSQL_PASS -B -N -e 'SHOW DATABASES' | xargs`; do
(/usr/local/mysql/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 - > ${db}.sql.gz)
done
tar zcf /home/backup/$DataBakName /home/backup/*.sql.gz
rm -rf /home/backup/*.sql.gz
cd /home/backup
ftp -v -n $FTP_IP << END
user $FTP_USER $FTP_PASS
type binary
cd $FTP_backup
delete $OldData
put $DataBakName
bye
END ``
使用crontab添加定时任务即实现定时备份.

No comments yet

Leave a comment

About me

I live in Tasmania, an island a little far from the rest of the world and very close to the sea.
Father of two little girls, have two puppies.

Work

Work in IT industry, AI is my working partner.