Mysql数据备份须知

取消外键约束
SET FOREIGN_KEY_CHECKS = 0;

备份SQL
....................

开启外键约束
SET FOREIGN_KEY_CHECKS = 1;