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 SET SQL_LOG_BIN=0 in your
script or whatever you're running.
For 5.0.19, here is the snippet of mysql -? that shows the variables
you can set:
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
auto-rehash TRUE
character-sets-dir (No default value)
default-character-set latin1
compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 0
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket (No default value)
table FALSE
debug-info FALSE
user (No default value)
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
show-warnings TRUE
-Sheeri
On 5/15/06, Mattias Andersson <[EMAIL PROTECTED]> 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.
When trying to run this mysql tells me:
/usr/bin/mysql: unknown option '--sql_log_bin'
I figure from the documentation that this should be possible:
mysql --help
---snip---
-O, --set-variable=name
Change the value of a variable. Please note that this
option is deprecated; you can set variables
directly with
--variable-name=value.
---snip---
Perhapps the problem comes from that this is a sessions-variable...?
The problem I would like to solve is to not bin-log some special data
imports.
Any one that could help me figure this out?
Thanks alot.
Regards,
/Mattias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
