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
