MySQL 导出数据结构 If you don't want to restore GTIDs, pass --set-gtid-purged=OFF.

最新推荐文章于 2023-12-12 14:05:32 发布

风华浪浪

最新推荐文章于 2023-12-12 14:05:32 发布

阅读量1.9k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/a6864657/article/details/99968549

版权

数据库专栏收录该内容

23 篇文章 0 订阅

订阅专栏

应用场景MYSQL导出数据结构

Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, 
even those that changed suppressed parts of the database. 
If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. 
To make a complete dump, pass --all-databases --triggers --routines --events.

解决

表
mysqldump -uroot -p --set-gtid-purged=OFF database table1 table2 > mysqldump.sql
库
mysqldump -h192.168.***.***  --set-gtid-purged=OFF  -uroot -p -P3306  -d 数据库名 > dump.sql