Re: How can I upload dumped data

2004-03-20 Thread Egor Egorov
Andre MATOS <[EMAIL PROTECTED]> wrote: > > I tried it, but it didn't work. > > ERROR 1217 at line 3483: Cannot delete or update a parent row: a foreign > key constraint fails > > I am using InnoDB... that's my problem... Add to the beginning of the dump file: SET FOREIGN_KEY_CHECKS=0; and S

Re: How can I upload dumped data

2004-03-19 Thread Andre MATOS
I tried it, but it didn't work. ERROR 1217 at line 3483: Cannot delete or update a parent row: a foreign key constraint fails I am using InnoDB... that's my problem... Thanks. Andre On Fri, 19 Mar 2004, Egor Egorov wrote: > Andre MATOS <[EMAIL PROTECTED]> wrote: > > Hi List, > > > > Once

Re: How can I upload dumped data

2004-03-19 Thread Egor Egorov
Andre MATOS <[EMAIL PROTECTED]> wrote: > Hi List, > > Once I have dumped my database using mysqldump how can I upload the data > again using the mysql command line (MySQL in ansi mode)? > mysql -u user_name -p database_name < dump_file.sql -- For technical support contracts, goto ht

How can I upload dumped data (fwd)

2004-03-19 Thread Andre MATOS
Hi List, Once I have dumped my database using mysqldump how can I upload the data again using the mysql command line (MySQL in ansi mode)? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

How can I upload dumped data

2004-03-19 Thread Andre MATOS
Hi List, Once I have dumped my database using mysqldump how can I upload the data again using the mysql command line (MySQL in ansi mode)? Thanks. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.