parameter being overwritten

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

Re: parameter being overwritten

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.htm l


On Wed, Jan 20, 2010 at 12:43 PM, Jerome Macaranas wro=
te:
> 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 con=
fig
> file or with CHANGE MASTER TO
>
> after some testing.. i saw the server-id =3D 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 =A0 =A0  = 2
> server-id =A0 =A0 =A0 =3D 2
> -- its good..
>
> ls -l ~/my.cnf -- file not found..
>
> print_defaults mysqld result
> --server-id=3D2
> -- 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 =3D 0?
>



--=20
- michael dykman
- mdykman@gmail.com

May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: parameter being overwritten

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org