You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
42 lines
1.0 KiB
42 lines
1.0 KiB
# docker exec mysql-service-sunday mysqldump -u backup_db --password=A@1qaz2wsxA@ gk_exam
|
|
|
|
TODAY=`date +"%d%b%Y"`
|
|
|
|
DB_NAME="${DB_NAME} sundayenglish_general"
|
|
DB_NAME="${DB_NAME} gk_oauth"
|
|
|
|
DOCKER_NAME="mysql-service-sunday"
|
|
MYSQL_USER="backup_db"
|
|
MYSQL_PASSWORD="A@1qaz2wsxA@"
|
|
|
|
DB_BACKUP_PATH="/var/backup_mysql/backup_db"
|
|
|
|
mkdir -p ${DB_BACKUP_PATH}/${TODAY}
|
|
|
|
for DB_NAME in ${DB_NAME}; do
|
|
|
|
docker exec ${DOCKER_NAME} mysqldump -u ${MYSQL_USER} \
|
|
--password=${MYSQL_PASSWORD} ${DB_NAME} \
|
|
| gzip > ${DB_BACKUP_PATH}/${TODAY}/${DB_NAME}.sql.gz
|
|
|
|
if [ $? -eq 0 ]; then
|
|
echo "Database backup successfully completed"
|
|
else
|
|
echo "Error found during backup"
|
|
exit 1
|
|
fi
|
|
done
|
|
|
|
|
|
##### Remove backups older than {BACKUP_RETAIN_DAYS} days #####
|
|
|
|
# DBDELDATE=`date +"%d%b%Y" --date="${BACKUP_RETAIN_DAYS} days ago"`
|
|
|
|
# if [ ! -z ${DB_BACKUP_PATH} ]; then
|
|
# cd ${DB_BACKUP_PATH}
|
|
# if [ ! -z ${DBDELDATE} ] && [ -d ${DBDELDATE} ]; then
|
|
# rm -rf ${DBDELDATE}
|
|
# fi
|
|
# fi
|
|
|
|
### End of script #### |