MySQL备份脚本

最新推荐文章于 2025-09-06 09:33:29 发布

weixin_34194551

最新推荐文章于 2025-09-06 09:33:29 发布

阅读量50

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/zping/p/4898597.html

#!/bin/sh
#本份数据库
#Local backup dir and backup bin setting
Local_Dir=/var/jfb/backup/mysql
Backup_Bin=/usr/bin/mysqldump

#Database setting
Db_Host=172.30.0.2
Db_Name=ec
Db_User=uu_db
Db_Pass=lok
Bak_File=$Db_Name`date +%Y-%m-%d-%H--%M`

#Begin to Backup
mkdir -p $Local_Dir
cd $Local_Dir
$Backup_Bin --force -q -h $Db_Host -u $Db_User -p$Db_Pass $Db_Name | gzip -c | cat >  $Bak_File.sql.gz