From: Jerome Macaranas
Date: January 20 2010 5:43pm
Subject: parameter being overwritten
List-Archive: http://lists.mysql.com/mysql/220319
Message-Id: <662701801001200943r24a729eax8d7df6f3bfccb5b0@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e6d59ec57fe3d1047d9c217d

--0016e6d59ec57fe3d1047d9c217d
Content-Type: text/plain; charset=ISO-8859-1

im trying to setup mysql slave but the things is it wont start because of
this errror:

--> ERROR 1200 (HY000): The server is not configured as slave; fix in config
file or with CHANGE MASTER TO

after some testing.. i saw the server-id = 0
through > show variables like 'server_id'


went to check server-id parameter in /etc/my.cnf
grep server-id /etc/my.cnf
#server-id      = 2
server-id       = 2
-- its good..

ls -l ~/my.cnf -- file not found..

print_defaults mysqld result
--server-id=2
-- its good

but again > show variables like server_id is showing "0"
what i had to do is set global parameter in mysqld cli w/c is not a good
thing..


additional info:

Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf /etc/my.cnf


is there anyway to trace why server-id = 0?

--0016e6d59ec57fe3d1047d9c217d--