使用 Wamp Server mysql 进行定时数据库复制进行主从复制

Question

我正在尝试在 wamp 服务器上使用主从复制来复制我的数据库。我对 my.ini 文件进行了以下更改：

# Number of threads allowed inside the InnoDB kernel.The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8

#Defining the directory for logs and database and the server id
log-bin=C:\wamp\logs\mysql-bin.log
binlog-do-db=bank
server-id=2

在主服务器上，我配置了此：

mysql> GRANT REPLICATION SLAVE 
-> ON *.* TO 'root'@'slave_ip' 
-> IDENTIFIED BY '';

在从服务器上，我配置了此：

mysql> CHANGE MASTER TO 
-> MASTER_HOST='(master_ip)', 
-> MASTER_PORT=3306, 
-> MASTER_USER='root', 
-> MASTER_PASSWORD='';

我收到错误： 错误 1198：无法对正在运行的从服务器执行此操作；首先运行停止从站。

所以我跑了 stop Slave 并没有发生任何事情。任何帮助将不胜感激。

Answer 1

在主设备上：

SHOW MASTER STATUS;

输出为：

+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |      107 | karbord_test |                  |
+------------------+----------+--------------+------------------+
1 row in set

在从设备上：

STOP SLAVE;

CHANGE MASTER TO
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=107;

START SLAVE;