List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:January 20 2010 7:24pm
Subject:Re: parameter being overwritten
View as plain text  
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
or
  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?

      http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html


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
> --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?
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
parameter being overwrittenJerome Macaranas20 Jan
  • Re: parameter being overwrittenMichael Dykman20 Jan
  • Re: parameter being overwrittenwalter harms21 Jan