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
