master机器的my.ini文件
IP:192.168.1.12
#This File was made using the WinMySQLAdmin 1.4 Tool
#2006-03-23 10:06:19

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=E:/mysql4.0/
#bind-address=192.168.2.210
datadir=E:/mysql4.0/data
#language=E:/mysql4.0/share/your language directory
#slow query log#=

#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
set-variable = max_connections=32000
set-variable = key_buffer_size=402649088
set-variable =thread_cache_size=16M

[WinMySQLadmin]
Server=E:/mysql4.0/bin/mysqld-nt.exe
user=root
password=mysqlpass

[mysqld]
server-id=1
log-bin=c:mysqllogsmysql_binary_log
binlog-do-db=testdb
binlog-ignore-db=mysql



==========================================
slave机器 的my.ini文件
IP:192.168.1.13

#This File was made using the WinMySQLAdmin 1.4 Tool
#2006-03-23 10:06:19

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=e:/mysql4.0/
#bind-address=192.168.2.210
datadir=e:/mysql4.0/data
#language=e:/mysql4.0/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
set-variable = max_connections=32000
set-variable = key_buffer_size=402649088
set-variable =thread_cache_size=16M

[WinMySQLadmin]
Server=e:/mysql4.0/bin/mysqld-nt.exe
user=root
password=mysqlpass

[mysqld]
log-bin=c:mysqllogsmysql_binary_log
server-id=2
master-host=192.168.1.12
master-user=testdb
master-password=123456
master-connect-retry=60
replicate-do-db=testdb



上面的配置好后都重启了
然后在slave 机器上执行slave start; 就出现下面这个提示，请高手指教，该如何解决？谢谢！！

ERROR 1198: This operation cannot be performed with a running slave, run SLAVE S
TOP first

在master 机器上执行
mysql> SHOW MASTER STATUSG
*************************** 1. row ***************************
            File: mysql_binary_log.002
        Position: 79
    Binlog_do_db: testdb
Binlog_ignore_db: mysql
1 row in set (0.00 sec)

在slave 机器上执行

mysql> SHOW slave STATUSG
*************************** 1. row ***************************
          Master_Host: 192.168.1.12
          Master_User: testdb
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File:
  Read_Master_Log_Pos: 4
       Relay_Log_File: user-543u494h0s-relay-bin.002
        Relay_Log_Pos: 4
Relay_Master_Log_File:
     Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
      Replicate_do_db: testdb
  Replicate_ignore_db:
           Last_errno: 0
           Last_error:
         Skip_counter: 0
  Exec_master_log_pos: 0
      Relay_log_space: 0
1 row in set (0.00 sec)

你的Slave 机的*.err 中有什么错误信息嘛？


你可以看下我 发的置顶贴，也许能帮你 找到寻找答案方向

The hint is already very obvious.

QUOTE:

---

原帖由 semirmyway 于 2008-5-30 11:32 发表
在slave 机器上执行

mysql> SHOW slave STATUSG
*************************** 1. row ***************************
          Master_Host: 192.168.1.12
          Master_User: testdb
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File:
  Read_Master_Log_Pos: 4
       Relay_Log_File: user-543u494h0s-relay-bin.002
        Relay_Log_Pos: 4
Relay_Master_Log_File:
     Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
      Replicate_do_db: testdb
  Replicate_ignore_db:
           Last_errno: 0
           Last_error:
         Skip_counter: 0
  Exec_master_log_pos: 0
      Relay_log_space: 0
1 row in set (0.00 sec)

---

你slave机器上Slave_IO_Running: Yes ，Slave_SQL_Running: Yes 这两个状态都是yes，说明slave已经启动了，你再执行start slave当然报错了。