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
• Status: Not a Bug
• Category: MySQL Server: Backup
• Severity: S4 (Feature request)
• Version: Any
• OS: Any
• CPU Architecture: Any
• Tags: mysqldump

[2 Feb 2010 20:00] Kevin Benton

Description:
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...