备份mysql数据库数据-----shell

最新推荐文章于 2024-10-18 09:37:29 发布

chongni9875

最新推荐文章于 2024-10-18 09:37:29 发布

阅读量101

点赞数

文章标签： shell 数据库 awk

原文链接：https://my.oschina.net/210920/blog/751016

版权

!/bin/bash

MysqlUser=root

PassWord=backup123

Port=3306

Socket="/data/$Port/mysql.sock"

MysqlCmd="mysql -u$MysqlUser -p$PassWord -S $Socket"

Database=$MysqlCmd -e "show databases;"|egrep -v "Database|_schema|mysql"

MysqlDump="mysqldump -u$MysqlUser -p$PassWord -S $Socket"

IP=ifconfig eth0|awk -F "[ :]+" 'NR==2 {print $4}'

BackupDir=/backup/$IP

[ -d $BackupDir ] || mkdir -p $BackupDir

for dbname in $Database

do

 [ ! -d /$BackupDir/$dbname ] && mkdir -p /$BackupDir/$dbname

 TABLE=`$MysqlCmd -e "show tables from $dbname;"|sed '1d'`

 for table in $TABLE

    do

      $MysqlDump $dbname $table|gzip >/$BackupDir/$dbname/${dbname}_${table}_$(date +%F).sql.gz

 done
done

转载于:https://my.oschina.net/210920/blog/751016