471,073 Members | 1,299 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

replication problem

Hi folks, trying to set up replication and I'm getting this problem
which I can't see how to fix despite reading of the manual and
google.

I have set up a master and a slave according to the manual. The
master runs 4.0.12 and the slave runs 4.0.14, they are both actually
on the same machine (it's a long story, but it's what I need). I
did LOAD DATA FROM MASTER on the slave which completed successfully,
and then I tried SLAVE START:

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

but.. it is!

on the slave:

mysql> show slave status\G
*************************** 1. row ***************************
Master_Host: 127.0.0.1
Master_User: repl
Master_Port: 3306
Connect_retry: 60
Master_Log_File: angora-bin.001
Read_Master_Log_Pos: 20102800
Relay_Log_File: angora-relay-bin.001
Relay_Log_Pos: 4
Relay_Master_Log_File: angora-bin.001
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 20102800
Relay_log_space: 8
1 row in set (0.00 sec)

On the master:

mysql> show master status;
+----------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+----------------+----------+--------------+------------------+
| angora-bin.001 | 24954609 | | |
+----------------+----------+--------------+------------------+
1 row in set (0.01 sec)

Any ideas what I missed?

--
"I remember the first time I made love. Perhaps it was not love exactly but I
made it and it still works."
-- The League Against Tedium

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

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.