备份MYSQL脚本

备份MYSQL脚本

#!/bin/sh# this shell to backup mysql#1413161683@qq.com (QQ:1413161683 DuChengJiu)_dbDir=/var/lib/mysql/_today=`date +%w`_bakDir=/usr/backup/$_today[ ! -d $_bakDir ] && mkdir -p $_bakDir#Create db tar archive#/usr/local/mysql/share/mysql/mysql.server stopservice mysqld stopfor db in `find $_dbDir -type d|tail -n +2`do echo "Do $db ...." realDb=`echo $db|awk -F / '{print $NF}'` echo "Backup $realDb ......" tar cvf $_bakDir/${realDb}.tar $db || echo "$realDb : 1" >>$_bakDir/backup-errordone#/usr/local/mysql/share/mysql/mysql.server startservice mysqld start#gzip backupfor zip in $_bakDir/*.tardo echo "Compress $zip ........" gzip -f $zipdonefind $_bakDir -name "*tar" -exec rm -f {} \;

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。