mysql 备份 Shell 脚本

mysql_backup.sh

#!/bin/sh

function backup(){
	cd /var/tmp/ 
	for databaseName in $*
	do
		sqlFileName=""$databaseName".sql"
		echo "exporting "$databaseName 

		# 导出数据库
		mysqldump -u user -ppassword $databaseName > sql/$sqlFileName
	done
	
	# 打包压缩
	echo "正在打包"
	tar zcvf sql.tar.gz sql/

	# 远程拷贝
	echo "正在发送到备份服务器"
	scp sql.tar.gz root@1.2.3.4:/var/tmp/
	
}

backup 'site1.cn' 'site2.com' 

# 恢复数据库
echo "正在恢复数据"
ssh root@1.2.3.4 "bash /var/tmp/mysql_restore.sh"