【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表空间,则需注意先创建好再导入,否则导入报错。

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值