首页 > 代码库 > 一个mysql的备份脚本(可以结合多实例进行调整)
一个mysql的备份脚本(可以结合多实例进行调整)
mysql数据库备份脚本:
#!/bin/bash #定义变量信息 USER=root PASS=redhat12345 SOCKET=/data/3306/mysql.sock CMD="mysql -u$USER -p$PASS -S $SOCKET" DUMP="mysqldump --opt -u$USER -p$PASS -S $SOCKET" DES="/usr/src/mysqlbackup" BACKUPTIME="date +%F-%H:%M" #目录判断 if [ ! -d "$DES/`date +%F`" ];then mkdir -p "$DES/`date +%F`" fi #mysqldump备份数据库 echo "----------------------------start backup mysql-------------------------------" for database in `$CMD -e "show databases" | sed ‘1,2d‘ | egrep -v "mysql|schema"` do $DUMP $database -B|gzip>$DES/`date +%F`/${database}.sql.gz if [ $? -eq 0 ];then echo "$database has been backup successful" else echo "$database has been not successful" fi /bin/sleep 5 done echo "---------------------------backup is end -------------------------------------"
执行结果如下:
[root@mysql-master mysqlbackup]# pwd /usr/src/mysqlbackup [root@mysql-master mysqlbackup]# ll 总用量 4 -rw-r--r-- 1 root root 805 12月 6 18:50 backup.sh [root@mysql-master mysqlbackup]# bash backup.sh ----------------------------start backup mysql------------------------------- dawnpro has been backup successful hangzhou has been backup successful james has been backup successful wanlong has been backup successful ---------------------------backup is end ------------------------------------- [root@mysql-master mysqlbackup]# ll 总用量 8 drwxr-xr-x 2 root root 4096 12月 6 18:56 2016-12-06 -rw-r--r-- 1 root root 805 12月 6 18:50 backup.sh [root@mysql-master mysqlbackup]# ll 2016-12-06/ 总用量 16 -rw-r--r-- 1 root root 512 12月 6 18:56 dawnpro.sql.gz -rw-r--r-- 1 root root 513 12月 6 18:56 hangzhou.sql.gz -rw-r--r-- 1 root root 511 12月 6 18:56 james.sql.gz -rw-r--r-- 1 root root 511 12月 6 18:56 wanlong.sql.gz mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | dawnpro | | hangzhou | | james | | mysql | | performance_schema | | wanlong | +--------------------+ 7 rows in set (0.00 sec)
做个简单的记录,后面有空再补充详细的注解或者对脚本进行优化
本文出自 “冰冻vs西瓜” 博客,请务必保留此出处http://molewan.blog.51cto.com/287340/1880184
一个mysql的备份脚本(可以结合多实例进行调整)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。