Bug #50851 RFE: Need --no-foreign-key-checks option to mysqldump
Submitted: 2 Feb 2010 20:00 Modified: 2 Feb 2010 20:21
Reporter: Kevin Benton Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Backup Severity:S4 (Feature request)
Version:Any OS:Any
Assigned to: CPU Architecture:Any
Tags: mysqldump

[2 Feb 2010 20:00] Kevin Benton
Need --no-foreign-key-checks option to mysqldump that will perform the same steps as documented in http://forums.mysql.com/read.php?28,15592,15888#msg-15888

This will make it much easier for administrators to be able to restore backups of entire databases without having to worry about the order tables are restored in.

It also makes sense that there would potentially be a --add-triggers-after-data-load option as well so that during the DML load that triggers would specifically be skipped presumably because the triggers have already fired in the backup and should not be re-run for each row being restored.  To make this work, --add-triggers-after-data-load could simply delay adding triggers to table definitions until after the DML was loaded.

How to repeat:
See description

Suggested fix:
See description
[2 Feb 2010 20:21] Kevin Benton
Never mind...