Thanks, Paul. You appear frustrated that I didn't look in the docs first. I had been to that page (and thoroughly read it) after Victoria's reply. Prior to the reply, I tried searching but wasn't sure what to search for, so didn't find what I was looking for. The real gist of my question was:
<<Is there a list of variables that I *can* use in the [client] section, or am I just doing something wrong.>> I'm trying to figure out why I couldn't just put it in the [client] section because I'm trying to understand the entire product on a deeper level. I've thoroughly read http://dev.mysql.com/doc/mysql/en/Option_files.html and it appears that this request (knowing all the config file options) has been made by others, so I felt no need to post it there in addition to the others. So back to my question... is looking at the command line options for a program a good way to figure out what can go into the option file or does that not always hold true? SHOW VARIABLES? I noticed that SET FOREIGN_KEY_CHECKS doesn't appear in the SHOW VARIABLES list. The only place I found it was by querying @@session.FOREIGN_KEY_CHECKS. Thanks, Lou ----- Original Message ----- From: "Paul DuBois" <[EMAIL 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 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. > > There is an example that shows how to use the variable on this page: > > http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html > > I got to this page by going to: > > http://dev.mysql.com/doc/mysql/en/index.html > > Then I typed foreign_key_checks into the search box and clicked the Go > button. The first page in the list of hits is the one shown above. > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
