List:General Discussion« Previous MessageNext Message »
From:Jerome Macaranas Date:January 20 2010 5:43pm
Subject:parameter being overwritten
View as plain text  
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
-- 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

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?

parameter being overwrittenJerome Macaranas20 Jan
  • Re: parameter being overwrittenMichael Dykman20 Jan
  • Re: parameter being overwrittenwalter harms21 Jan