#!/bin/bash

base_dir='/home/reghao/Dropbox/tnb'
dest_dir='/home/reghao/Dropbox/tnb1'
cd ${base_dir}

#######################################################################################################################
# 导出数据库
#######################################################################################################################
host='192.168.0.209'
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

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

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

mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_store_node > file_store_node.sql
mysqldump -h${host} -u${username} -p${password} --lock-all-tables --flush-logs --set-gtid-purged=off ${db3} file_store_volumes > file_store_volumes.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