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]

Reply via email to