mysqldump exclude 导出时排除table

1、mysqldump name_of_db --ignore-table = name_of_db.name_of_table
2、
mysqldump -u username -p database_name --no-data > table_structure.sql

host=172.16.0.3
export MYSQL_PWD=123456
today=$(date +%F.%H%M)
item=test
mysqldump -gtid-purged=OFF -h${host} -u${item}user ${item}db --no-data > ${item}_${today}.sql

相关日志