Place the SET FOREIGN_KEY_CHECKS=0 in the beginning of the file that contains the backup or run this command from the command line before you import the file.
-----Original Message----- From: Lou Olsten To: [EMAIL PROTECTED] Sent: 4/29/04 9:38 AM Subject: [client] var not working Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's data by turning off SET FOREIGN_KEY_CHECKS = 0 during the restore. I then tried to go to the machine where the dumps were going to be restored and set this variable in the [client] section of my.cnf. But when I try to connect after that, I get an: "ERROR: unknown variable 'foreign_key_checks=0'. I then tried using: set variable=foreign_key_checks=0 ...but got the same result. Is there a list of variables that I *can* use in the [client] section, or am I just doing something wrong. Thanks, Lou Olsten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
