Respondendo,
quinta-feira, 6 de março de 2003, 19:06:06, Mensagem Original:
RM> I have a DB where all of the tables are InnoDB, and there are a few
RM> straightforward FOREIGN KEY constraints. I would like to use mysqldump to
RM> back up the data or move it to another machine.
RM> The problem I'm running into is that when I try to import the data using
RM> mysql, the data is imported in the order in which it was dumped, that is to
RM> say, alphabetically by table.
before import the MySQLDump file type:
SET FOREIGN_KEY_CHECKS=0;
after import:
SET FOREIGN_KEY_CHECKS=1;
This command disable and enable FOREIGN KEY CHECKS ;)
RM> This ends up violating the key constraints. Is there a way to specify the
RM> order in which tables are dumped from mysqldump?
Yes. The mysqldump not respect the rules of key constraints.
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 221602060
$ look into "my eyes" Phone : +55 041 296-2311 r.112
look: cannot open my eyes Fax : +55 041 296-6640
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
