Hooray! The last problem was b/c I did not have the same InnoDB settings in my cnf file.
Again, thank you all for your time in this matter! Gabe -----Original Message----- From: [EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 11:29 AM To: Victoria Reznichenko; [EMAIL PROTECTED] Subject: RE: InnoDB - Foreign Key - Error 150. Victoria That seemed to work well, thank you. However, I received another error that I am not sure how to troubleshoot during the restore: ERROR 1114 at line 83 in file: '/bb/bin/mysql/backups/archive_4320.sql': The table 'cur_reject_tk_sum' is full What can I do here? Thanks - Gabe -----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 10:35 AM To: [EMAIL PROTECTED] Subject: Re: InnoDB - Foreign Key - Error 150. "Tucker, Gabriel" <[EMAIL PROTECTED]> wrote: > Marvin > > I believe that is the problem with the restore. When I create the = > archive file using the mysqldump command and options previously listed, = > I get the create table in the order listed below and thus, the foreign = > key constraint is created on table cur_reject_tk_sum before the = > object_type table has been created. > > Now my questions are: > [1] Is the above scenario my problem? > [2] Is so, how can I correct it? Is this a problem with the way I am = > using mysqldump? [see commands below] Or, is this a problem with how I = > am restoring the database? [Which, I create a "default" mysql database = > on its own port and then run from the prompt "mysql --port=3D = > --socket=3D -p < archive_file.sql" Add to the beginning of the dump file command: SET FOREIGN_KEY_CHECKS = 0; and then restore tables. Or in the mysql client execute the following commands: SET FOREIGN_KEY_CHECKS = 0; SOURCE archive_file.sql; SET FOREIGN_KEY_CHECKS = 1; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]