Bug #405 mysql dump problems

• Submitted: 8 May 2003 23:08
• Modified: 9 May 2003 2:18
• Reporter: mina R Waheb
• Status: Not a Bug
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 4
• OS: FreeBSD (FreeBSD 4.7)
• CPU Architecture: Any

[8 May 2003 23:08] mina R Waheb

Description:
hello ,
while i create my datbase and my tables i found some problems i dunno if it important or no
here it is :
if i create table call "B" whatever in it Type = InnoDB.
then i create table called "A" and create Foreign Key between the 2 tables ,
then i use mysqldump to dump the hole database its will dump table "A" then  DUMP table "B".
which will create problems if i try to use this dump if the tables too big .
thanks alot

How to repeat:

[9 May 2003 2:18] Heikki Tuuri

Use

SET FOREIGN_KEY_CHECKS=0;

in the import session.