Re: Replication problem: Slave not starting

2003-07-02 Thread gerald_clark


Andrew Staples wrote:

I've setup my my.cnf file on the slave as:

[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword
Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
replicateuser
replicatepassword
3306
60
 

This indicates that replication is running.

Show slave status indicates NO under Slave_running, and I get:

mysql slave start;
ERROR 1200: The server is not configured as slave, fix in config file or
with CHANGE MASTER TO
You would get this message on the master.
You are running this command on the slave?
Server has been restarted.  Version is 3.23.56

Any ideas?

Andrew

Instead of trying to build newer and bigger weapons of destruction, we
should be 
thinking about getting more use out of the ones we already have.

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Replication problem: Slave not starting

2003-07-01 Thread Andrew Staples
I've setup my my.cnf file on the slave as:

[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword

Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
replicateuser
replicatepassword
3306
60

Show slave status indicates NO under Slave_running, and I get:

mysql slave start;
ERROR 1200: The server is not configured as slave, fix in config file or
with CHANGE MASTER TO

Server has been restarted.  Version is 3.23.56

Any ideas?

Andrew

Instead of trying to build newer and bigger weapons of destruction, we
should be 
thinking about getting more use out of the ones we already have.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]