- 论坛徽章:
- 0
|
【求助】数据库无法同步,err文件请大家分析一下
两边的数据库版本一样都是4.0.23
主端系统是win2003
从端系统是win2000
slave端数据库启动:err文件记录如下:
[quote]050202 15:49:16 InnoDB: Started
050202 15:49:16 Slave SQL thread initialized, starting replication in log 'FIRST' at position 176, relay log '.\11111l-relay-bin.031' position: 254
MySql: ready for connections.
Version: '4.0.23-nt-log' socket: '' port: 端口 Source distribution
050202 15:49:45 Slave I/O thread: connected to master '账号@主端ip:端口', replication started in log 'mysqllog.001' at position 176[/quote]
slave端里用mcc执行 slave stop之后 err文件就会出现:
[quote]050202 15:57:28 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050202 15:57:28 Slave I/O thread killed while reading event
050202 15:57:28 Slave I/O thread exiting, read up to log 'mysqllog.001', position 1741
050202 15:57:28 Error reading relay log event: slave SQL thread was killed
050202 15:58:42 Slave SQL thread initialized, starting replication in log 'FIRST' at position 1741, relay log '.\11111-relay-bin.032' position: 1608[/quote]
然后再slave start ;err文件记录如下:
[quote]050202 15:58:42 Slave SQL thread initialized, starting replication in log 'FIRST' at position 1741, relay log '.\11111relay-bin.032' position: 1608[/quote]
====================================
之后测试数据库同步效果---失败,不能同步:cry;
还请各位老大指点 ;应该怎么办 |
|