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'
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
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
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