Re: Setting sql_log_bin

2006-05-16 Thread Mattias Andersson
net_buffer_length 16384 select_limit 1000 max_join_size 100 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

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

Unknown error - processes/queries hangs

2006-02-15 Thread Mattias Andersson
Hi. We are seeing problems when trying to upgrade from version 4.0.23 to version 5.0.18 (using standard RPM's) The upgrade includes new hardware and we are exporting our databases with mysqldump and reading them in on the new database server. All seams to be just fine and enabling some