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]