Docker MySQL数据库备份脚本参考

Docker MySQL数据库备份脚本参考

backup.sh

#!/bin/sh
# useage
# /path/to/backup.sh dbName
# /path/to/backup.sh dbName
dateStr=`date +%Y%m%d`
baseDir=/opt/docker/mysql/backup/
dbName=$1
dbDir=$baseDir''$dbName
if [ ! -d $dbDir ];then
mkdir $dbDir
echo "mkdir path:"$dbDir
fi
dbFileName=$dbName'-'$dateStr'.sql'
dbFilePath=$dbDir'/'$dbFileName
echo $dbFilePath
docker exec mysql  sh -c 'exec mysqldump --databases '$dbName' -uroot -p"$MYSQL_ROOT_PASSWORD"' > $dbFilePath
cd $dbDir && tar -cvzf  $dbFileName'.tgz' $dbFileName
rm -rf $dbFilePath

备份某个库

db-backup.sh

#!/bin/sh
#backup your_db_name
/path/to/backup.sh your_db_name

Shell MySQL docker

https://www.leftso.com/article/2407250933526301.html