"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]
