tnb0/db/exec_tnb_backup_restore.sh

#!/bin/bash

###############################################################################
# 还原整个数据库数据
###############################################################################

base_dir='/home/reghao/data/bak/20260523/'
cd ${base_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'

# 还原整个数据库数据
echo "restore ${db1} at "`date +'%Y-%m-%d %H:%M:%S'`
# mysql -h${host} -u${username} -p${password} ${db1} < ${db1}.sql
docker exec -i mysql80 mysql -h${host} -u${username} -p${password} ${db1} < ${db1}.sql
echo "${db1} data restored at "`date +'%Y-%m-%d %H:%M:%S'`

echo "restore ${db2} at "`date +'%Y-%m-%d %H:%M:%S'`
# mysql -h${host} -u${username} -p${password} ${db2} < ${db2}.sql
docker exec -i mysql80 mysql -h${host} -u${username} -p${password} ${db2} < ${db2}.sql
echo "${db2} data restored at "`date +'%Y-%m-%d %H:%M:%S'`

echo "restore ${db3} at "`date +'%Y-%m-%d %H:%M:%S'`
# mysql -h${host} -u${username} -p${password} ${db3} < ${db3}.sql
docker exec -i mysql80 mysql -h${host} -u${username} -p${password} ${db3} < ${db3}.sql
echo "${db3} data restored at "`date +'%Y-%m-%d %H:%M:%S'`

echo "restore ${db4} at "`date +'%Y-%m-%d %H:%M:%S'`
# mysql -h${host} -u${username} -p${password} ${db4} < ${db4}.sql
docker exec -i mysql80 mysql -h${host} -u${username} -p${password} ${db4} < ${db4}.sql
echo "${db4} data restored at "`date +'%Y-%m-%d %H:%M:%S'`