Bug #15827 to be able to set foreign_key_checks with mysqlimport
Submitted: 17 Dec 2005 15:48 Modified: 12 Jan 2012 17:12
Reporter: Nizamettin OZPOLAT Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:any OS:Any (any)
Assigned to: CPU Architecture:Any

[17 Dec 2005 15:48] Nizamettin OZPOLAT
To backup database we use mysqldump and to restore database use mysqlimport. So while restoring database foreign keys causes problem. If it was possible to use foreign_key_checks variable with mysqlimport it would be very very nice. But at the moment it is not possible. Could you please add disable foreign_key_checks to mysimport as a parameter.

How to repeat:
mysqldum -Q dbname -T /dir/
database must have tables which has foreign keys and the referenced table name must come after the primary table.
[12 Jan 2012 17:12] Sveta Smirnova
Thank you for the reasonable feature request.