If the server-id in your variables is not what you have in your
config, then either:
a) that is not the config file mysql is using
b) your build of mysql is seriously broken.
If you are able toget the server configured correctly, there still
will be the matter of synchronizing the data from the master and then
issuing the' CHANGE MASTER TO..' statement as indicated.
You have read this?
On Wed, Jan 20, 2010 at 12:43 PM, Jerome Macaranas <jerome.m@stripped> wrote:
> 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?
- michael dykman
May the Source be with you.