目标服务器的mysql日志中有以下错误信息: 120319 17:43:30 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236) 120319 17:43:30 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
在同一服务器上,直接访问即可
#主服务器设置
log-bin="D:/Program Files/MySQL/MySQL Server 5.0/log.txt"
server-id=1
#sql-bin-update-same
binlog-do-db=backup_test#从服务器设置
server-id=2
master-host=172.16.4.29
master-user=backup
master-password=123
master-port=3306
master-connect-retry=60
replicate-do-db=backup_test
#replicate-do-db-table=backup_test.students'Waiting for master to send event', '172.16.4.29', 'backup', 3306, 60, 'log.000004', 305, 'lenovo-2b50071c-relay-bin.000009', 229, 'log.000002', 'Yes', 'No', 'backup_test', '', '', '', '', '', 1062, 'Error 'Duplicate entry '1' for key 1' on query. Default database: 'backup_test'. Query: 'INSERT INTO `backup_test`.`students` (`name`,`age`,`sex`) VALUES ('u1','18','1')'', 0, 98, 2731, 'None', '', 0, 'No', '', '', '', '', '',
120319 17:43:30 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
120319 17:43:30 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log