Andre:
If you are using enforcing FK constraints it may be that the tables are in
the wrong order.
Try inserting the line
SET foreign_key_checks = 0;
at the front of the file and
SET foreign_key_checks = 1;
at the end, then try again.
Hope this helps.
Best Regards,
Boyd E. Hemphill
MySQL Certified Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2287
M: (713) 252-4688
-----Original Message-----
From: Andre Mato [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 9:00 AM
To: [EMAIL PROTECTED]
Subject: Restoring dump file problem
Hi List,
Today I got a surprise when I tried to restore a dump file did yesterday. I
did not work. I don't know if because is too big, I don't think so (just
30000 lines). However, when I remove one table "AuditTrail" that tracks
changes in the database, it worked.
I am using MySQL 4.0.18-standard with InnoDB on Mac OS X 10.3.5.
Is there any issue related a dumped file size?
Thanks!!!
Andre
--
Andre Matos
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
