mysql - 尝试复制数据库时出现相同的 ID 错误

Question

我无法将数据库从实时服务器复制到本地服务器(可从外部访问)。

我在主服务器上遇到了这个错误

Fatal error: The slave I/O thread stops because m
aster and slave have equal MySQL server ids; these ids must be different for rep
lication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).

在主服务器上，当我键入 SHOW SLAVE STATUS\G

在 Phpmyadmin 上我得到这个错误:

Slave IO Thread not running!

我的master my.cnf文件

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
server-id=1392211409
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=vapes4you
binlog_format=ROW
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

我的slave文件是

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
server-id=1392211002
master-host=********
master-user=vapesbackup
master-password=********
master-port=3306
replicate-do-db=dbname
master-connect-retry=60
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

谁能帮帮我？感谢阅读

Answer 1

如果命令 show variables like 'server_id'; 给你不同的 ID，那么你可能在设置复制时输入了它自己的 IP 地址。

CHANGE MASTER TO MASTER_HOST = **'**192.168.1.155**'**, MASTER_USER = 'replicator', MASTER_PASSWORD = 'passwd', MASTER_LOG_FILE = 'mysql-bin.000002', MASTER_LOG_POS = 107;