> "jim" <[EMAIL PROTECTED]> wrote: > > > >> Does this machine have a valid server-id? Run show variables like > >> 'server_id' from the mysql monitor. > > > > Interesting. The my.cnf says "server-id = 75" but the "show_variables;" > > command says server_id 0 (zero). > > > > Why would that be, and could it be the problem? > > Where is my.cnf located? > Does MySQL server read my.cnf? >
That was it! In this instance, the my.cnf was in /usr/local/mysql/. Moving it in to data/ fixed the problem, though I don't know why. I thought I was telling the startup script to find the file in mysql/ . Thanks very much to all who helped. > > > >>Also, is there anything in the *.err > >> file on this machine? > > > > Nothing but record of server startups and shutdowns. > > > >> > >> -----Original Message----- > >> From: jim > >> To: [EMAIL PROTECTED] > >> Sent: 4/14/04 3:26 PM > >> Subject: Server not configured as slave > >> > >> Hi, > >> > >> Can anyone suggest some troubleshooting tips when setting up a > >> slave and getting the error: > >> > >> ERROR 1200: The server is not configured as slave, fix in config > >> file or with CHANGE MASTER TO > >> > >> ? > >> > >> The master is already running with other slaves. I have granted > >> permission and copied the relevant config file information from > >> the other slaves to the new slave. > >> > >> > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
