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
: [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
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
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
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
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
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
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