Bug #67486 export to .sql with FOREIGN KEY
Submitted: 6 Nov 2012 15:22 Modified: 7 Nov 2012 18:55
Reporter: Lieven Roegiers Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.5.25a OS:Any (win7)
Assigned to: CPU Architecture:Any
Tags: exportfile, inserterror, sqlscript

[6 Nov 2012 15:22] Lieven Roegiers
I was running a backup into a database when he stops with an error(errno:121)

the table has one FOREIGN KEY the problem was that the table where he was looking not exist so when table was on the right place he running right 

How to repeat:
# mysql -uroot -p  testorder < testorder-##-##-##.sql

Suggested fix:
can you put first the tables with no FOREIGN KEY en then in downline the right tables so then is the error resolved
[7 Nov 2012 11:53] Lieven Roegiers
The backup was made from mysqladmin and it was,when the data was insert to the database.
[7 Nov 2012 18:55] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #16181