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