469,268 Members | 1,025 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,268 developers. It's quick & easy.

Replication Problem...

Hello All,

I have setup Replication on two Redhat linux box 7.3 and 9.0 with
MySQL-4.0.13 Running..

On Master the my.cnf is
==================
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
server-id = 1
log-bin

[mysqldump]
quick
max_allowed_packet = 16M

On Slave it is
=============
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib
master-host=66.xxx.xxx.xx3
master-user=repl
master-password=password
server-id=2
replicate-do-db=database

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

When I start Slave on the slave box it says this:
mysql> SLAVE START;
ERROR 1200: The server is not configured as slave, fix in config file or
with CHANGE MASTER TO

So I Executed This:
mysql> CHANGE MASTER TO MASTER_HOST='66.xxx.xxx.xx3',
MASTER_USER='repl',
MASTER_PASSWORD='password',MASTER_LOG_FILE='server-bin.004',
MASTER_LOG_POS=4994;

and START SLAVE but the same error occurs.

I have the master.info and relay-info
cat master.info
============
4

test

3306
60

cat relay-log.info
=============
../server-relay-bin.001
4

0

Any Help will be Appreaciated.

Thank You,
Tina.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1749

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Andras Kovacs | last post: by
2 posts views Thread by HJ | last post: by
9 posts views Thread by David W. Fenton | last post: by
8 posts views Thread by sat | last post: by
3 posts views Thread by Gert van der Kooij | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.