That is not a mysqld option, it's a session variable: mysql> select @@global.sql_warnings; ERROR 1238 (HY000): Variable 'sql_warnings' is a SESSION variable
On Dec 20, 2007 9:14 AM, Martijn van den Burg <[EMAIL PROTECTED]> wrote: > Hi, > > I'm having issues with replication breaking on one machine (Linux, x64) > but continuing normal on the other (Solaris). > > Both run MySQL 5.0.18-standard. > > The only difference betweenn the configuration of teh two is the setting > of sql_notes and sql_warnings. > > I want to find out if that causes the problem. According > http://dev.mysql.com/doc/refman/5.0/en/mysqld-option-tables.html I > should be able to set them in the config file (I'm using mysqld_multi), > but no matter what I use (sql_warnings=0, sql_warnings=off, change > sql_warnings to sql-warnings): every time mysqld refuses to start, > complaining that it does not know the variable 'sql_warnings'. > > How to set sql_notes and sql_warnings at server start up? Did I hit a > bug? > > I am aware that there's a bug in 5.0.18 with the /display/ of the value > of sql_warnings and -notes, http://bugs.mysql.com/bug.php?id=16195, > could that be related? > > > Regards, > > Martijn van den Burg > > -- > The information contained in this communication and any attachments is > confidential and may be privileged, and is for the sole use of the intended > recipient(s). Any unauthorized review, use, disclosure or distribution is > prohibited. Unless explicitly stated otherwise in the body of this > communication or the attachment thereto (if any), the information is provided > on an AS-IS basis without any express or implied warranties or liabilities. > To the extent you are relying on this information, you are doing so at your > own risk. If you are not the intended recipient, please notify the sender > immediately by replying to this message and destroy all copies of this > message and any attachments. ASML is neither liable for the proper and > complete transmission of the information contained in this communication, nor > for any delay in its receipt. > > > -- > 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]
