mysql备份每个库下面每个表
发布时间：2022-04-01 10:57:44 所属栏目：MySql教程 来源：互联网
导读：#!/bin/bash MYUSER=root MYPASS=123456 HOST=localhost BACKUPDIR=/backup_mysql DATE=`date -I` RETENTION=20 #MYSQLDATA=/var/lib/mysql [ ! -d $BACKUPDIR/$DATE ] mkdir -p $BACKUPDIR/$DATE DBS=`mysql -u$MYUSER -p$MYPASS -Bse show databases|gre
|
#!/bin/bash MYUSER="root" MYPASS="123456" HOST="localhost" BACKUPDIR="/backup_mysql" DATE=`date -I` RETENTION=20 #MYSQLDATA="/var/lib/mysql" [ ! -d $BACKUPDIR/$DATE ] && mkdir -p $BACKUPDIR/$DATE DBS=`mysql -u$MYUSER -p$MYPASS -Bse "show databases"|grep -v "information_schema" |grep -v "test"` for db_name in $DBS do mkdir -p $BACKUPDIR/$DATE/$db_name tables=`mysql -u$MYUSER -p$MYPASS -Bse "use $db_name;show tables"` for table_name in $tables do mysqldump -u$MYUSER -p$MYPASS -h$HOST --single-transaction --master-data=2 $db_name $table_name >$BACKUPDIR/$DATE/$db_name/$table_name.sql done done （编辑：扬州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐