[client] var not working

2004-04-29 Thread Lou Olsten
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

Re: [client] var not working

2004-04-29 Thread Ken Menzel
: [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

RE: [client] var not working

2004-04-29 Thread Victor Pendleton
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

Re: [client] var not working

2004-04-29 Thread Victoria Reznichenko
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

Re: [client] var not working

2004-04-29 Thread Paul DuBois
At 10:38 -0400 4/29/04, Lou Olsten 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

Re: [client] var not working

2004-04-29 Thread Lou Olsten
PROTECTED] To: Lou Olsten [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 29, 2004 11:21 AM Subject: Re: [client] var not working At 10:38 -0400 4/29/04, Lou Olsten wrote: Per a response from Victoria (thanks, BTW!) I see that I can reload my InnoDB RI's data by turning off SET

Re: [client] var not working

2004-04-29 Thread Paul DuBois
At 12:22 -0400 4/29/04, Lou Olsten wrote: Thanks, Paul. You appear frustrated that I didn't look in the docs first. Um, no. I gave instructions for finding the answer to a question that you were asking. I don't think that translates into any frustration about your use of the manual. I didn't

Re: [client] var not working

2004-04-29 Thread Lou Olsten
Paul, please see below... - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Lou Olsten [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 29, 2004 1:00 PM Subject: Re: [client] var not working At 12:22 -0400 4/29/04, Lou Olsten wrote: Thanks, Paul. You appear