shell备份数据库

/bin/bash

BAKPATH=/opt/mysql

MYUSER=root

MYPASSWD=123456

SOCKET=/data/3308/mysql.sock

MYCMD="mysql -u$MYUSER -p$MYPASSWD -S $SOCKET"

MYSQLDUMP=mysqldump -u$MYUSER -P$MYPASSWD -S $SOCKET -x -F -R

[ ! -d $BAKPATH ] && mkdir -p $BAKPATH

DBLIST=`$MYCMD -e "show databases; | sed 1d" |egrep -Evi "mysql|info" `

for dbname in DBLIST

do

TLIST=`$MYCMD -e "show tables from $dbname;" | sed 1d`

for tname in $TLIST

do

mkdir -p $BAKPATH/$dbname

$MYSQLDUMP $dbname $tname |gzip >/$BAKPATH/$dbname/${tname}_$(date +%F).sql.gz

done

$MYSQLDUMP $dbname |gzip > /$BAKPATH/${dbname}_$()$(date +%F).sql.gz

done

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!