MySQL Bugs: #15827: to be able to set foreign_key

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:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	any	OS:	Any (any)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Thank you for the reasonable feature request.