| 123456789101112131415161718192021222324252627282930313233343536 |
- #!/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
|
