List:General Discussion« Previous MessageNext Message »
From:walter harms Date:January 21 2010 8:14am
Subject:Re: parameter being overwritten
View as plain text  

Jerome Macaranas schrieb:
> 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?
> 

To make sure that mysql is actualy reading the file you may use strace (see man strace)
and
look if the my.cnf is realy read.

re,
 wh
Thread
parameter being overwrittenJerome Macaranas20 Jan
  • Re: parameter being overwrittenMichael Dykman20 Jan
  • Re: parameter being overwrittenwalter harms21 Jan