"Lou Olsten" <[EMAIL PROTECTED]> wrote: > 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.
You should add the following statement to the beginning of the dump file: SET FOREIGN_KEY_CHECKS = 0; or load dump file like: mysql> SET FOREIGN_KEY_CHECKS = 0; mysql> SOURCE dump_file.sql; mysql> 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]