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

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

Reply via email to