【MySQL】mysqldump的限制--注意事项

mysqldump的限制

Restrictions
mysqldump does not dump the INFORMATION_SCHEMA, performance_schema, or sys schema by default. To dump any of these, name them explicitly on the command line. You can also name them with the --databases option. For INFORMATION_SCHEMA and performance_schema, also use the --skip-lock-tables option.
mysqldump does not dump the NDB Cluster ndbinfo information database.
mysqldump does not dump InnoDB CREATE TABLESPACE statements.
It is not recommended to restore from a dump made using mysqldump to a MySQL 5.6.9 or earlier server that has GTIDs enabled. See Section 16.1.3.6, “Restrictions on Replication with GTIDs”.
mysqldump includes statements to recreate the general_log and slow_query_log tables for dumps of the mysql database. Log table contents are not dumped.
If you encounter problems backing up views due to insufficient privileges, see Section 23.9, “Restrictions on Views” for a workaround.

mysqldump的限制：
（1）mysqldump默认不会导出INFORMATION_SCHEMA, performance_schema, sys架构，若要导出需单独指定。
（2）mysqldump不导出NDB集群 ndbinfo信息数据库
（3）mysqldump不会导出InnoDB create tablespace的语句
（4）不建议用mysqldump导出后恢复到开启GTIDs的MySQL5.6.9或之前的版本
（5）mysqldump包含重建 mysql库中general_log 和slow_query_log的语句，不转储Log表内容

注意：
既然mysqldump不包含innodb创建表空间的语句，那若有general表空间，则需注意先创建好再导入，否则导入报错。