且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

具有外键表约束的备份MySQL模式

更新时间:2021-12-06 08:45:13

mysqldump也会创建外键转储... 它添加了如下语法:

mysqldump create the dump of foreign keys as well... it adds syntax like:

mysql> SET foreign_key_checks = 0;
mysql> SOURCE dump_file_name;
mysql> SET foreign_key_checks = 1;

您可以在以下位置阅读该手册: http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html 用于外键的mysqldump

You can read the manual at: http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html for mysqldump of foreign keys