Re: Setting sql_log_bin

2006-05-16 Thread Mattias Andersson
Ooh. I can from cmd-line not set any variable not listed there. That explains it all. Yes, I will put the command in the script-file instead then. Thanks alot. /Mattias sheeri kritzer wrote: I don't know what version you're running, but a mysql -? will show you the variables you can set. It'

Re: Setting sql_log_bin

2006-05-15 Thread Chris White
On Monday 15 May 2006 05:10 am, Mattias Andersson wrote: > Hi. > > I can't figure out how to set the session variable SQL_LOG_BIN when > using the mysql command-line client. > I want to do something like: #mysql -u root -pmypasswd --sql_log_bin = 0 > < somefile.sql. could be the fact that you have

Re: Setting sql_log_bin

2006-05-15 Thread sheeri kritzer
I don't know what version you're running, but a mysql -? will show you the variables you can set. It's not ALL variables you can set that way, just a few. You will see that the variable you're trying to set cannot be set via a command on the commandline. However, your first command could be to

Setting sql_log_bin

2006-05-15 Thread Mattias Andersson
Hi. I can't figure out how to set the session variable SQL_LOG_BIN when using the mysql command-line client. I want to do something like: #mysql -u root -pmypasswd --sql_log_bin = 0 < somefile.sql. When trying to run this mysql tells me: /usr/bin/mysql: unknown option '--sql_log_bin' I figure