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=arch...@jab.org
