One minute
Disabling foreign key check on MySQL
Disabling foreign key check on MySQL.
Useful when you need to quickly restore a backup.
SET FOREIGN_KEY_CHECKS = 0;
SOURCE db_xyz.sql;
SET FOREIGN_KEY_CHECKS = 1;
Read other posts
One minute
Useful when you need to quickly restore a backup.
SET FOREIGN_KEY_CHECKS = 0;
SOURCE db_xyz.sql;
SET FOREIGN_KEY_CHECKS = 1;