tnb0/db/exec_tnb_dump.sh

#!/bin/bash

sql_dir='/home/reghao/Dropbox/tnb'
cd ${sql_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'

# 导出数据库结构
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db1} > ${db1}.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db2} > ${db2}.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db3} > ${db3}.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db4} > ${db4}.sql

docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db1} > ${db1}.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db2} > ${db2}.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off -d ${db3} > ${db3}.sql
# nacos_config 导出全部数据 
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db4} > ${db4}.sql

# 导出表数据
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db1} account_user_registry > account_user_registry.sql

# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db2} file_oss_config > file_oss_config.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db2} vod_post_category > vod_post_category.sql

# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_oss_config > file_oss_config.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_store_volume > file_store_volume.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_upload_channel > file_upload_channel.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_user_key > file_user_key.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_user_node > file_user_node.sql
# mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_meta --where="file_type=1000" > file_meta.sql

docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db1} account_user_registry > account_user_registry.sql

docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db2} file_oss_config > file_oss_config.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db2} vod_post_category > vod_post_category.sql

docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_store_node > file_store_node.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_store_volume > file_store_volume.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_upload_channel > file_upload_channel.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_user_key > file_user_key.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_user_node > file_user_node.sql
docker exec -i mysql80 mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_meta --where="file_type=1000" > file_meta.sql