#!/bin/bash

###############################################################################
# 备份整个数据库结构和数据
###############################################################################

base_dir='/home/reghao/data/bak/'
dest_dir=${base_dir}/`date +'%Y%m%d'`
mkdir -p ${dest_dir}
cd ${dest_dir}

host='127.0.0.1'
username='test'
password='Test_123456'
db1='tnb_account_tdb'
db2='tnb_content_tdb'
db3='tnb_oss_tdb'
db4='nacos_config'
for((i=1; i<=4; i++));
do
    db_name=$(eval echo \${db$i})
    echo "dump ${db_name} at "`date +'%Y-%m-%d %H:%M:%S'`
    # 导出整个数据库结构和数据
	# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs ${db_name} > ${db_name}.sql
    docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=OFF ${db_name} > ${db_name}.sql
    echo "${db_name} data dumped at "`date +'%Y-%m-%d %H:%M:%S'`
done

# 导出和还原单个表结构和数据
# docker exec -i mysql80 mysqldump -h192.168.0.209 -utest -pTest_123456 --lock-all-tables --flush-logs --set-gtid-purged=off tnb_content_tdb vod_video_post > vod_video_post1.sql
# docker exec -i mysql80 mysql -h192.168.0.209 -utest -pTest_123456 tnb_content_tdb < vod_video_post1.sql

# 导出和还原单个数据库结构和数据
# docker exec -i mysql80 mysqldump -h192.168.0.209 -utest -pTest_123456 --lock-all-tables --flush-logs --set-gtid-purged=OFF tnb_account_tdb > tnb_account_tdb.sql
# docker exec -i mysql80 mysql -h192.168.0.209 -utest -pTest_123456 tnb_account_tdb > tnb_account_tdb.sql