就是希望两台在不同机房的服务器里面的mysql数据库能够互相备份。http://www.diybl.com/course/6_system/linux/Linuxjs/2008617/125967.html
看了这篇文章，照着做了一下，Slave_IO_Running | Slave_SQL_Running 这两个字段为 NO|YES，而不是文章里说的“YES|YES”，按照第四步的做完还是这样。哪位前辈能给指点一下，谢谢了！
看了这篇文章，照着做了一下，Slave_IO_Running | Slave_SQL_Running 这两个字段为 NO|YES，而不是文章里说的“YES|YES”，按照第四步的做完还是这样。哪位前辈能给指点一下，谢谢了！
InnoDB: a new database to be created!
090729 14:34:24 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090729 14:34:24 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090729 14:34:24 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090729 14:34:25 InnoDB: Started; log sequence number 0 0
090729 14:34:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
090729 15:07:13 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown090729 15:07:13 InnoDB: Starting shutdown...
090729 15:07:15 InnoDB: Shutdown completed; log sequence number 0 43655
090729 15:07:15 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete090729 15:07:16 InnoDB: Started; log sequence number 0 43655
090729 15:07:16 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=vm2003-relay-bin' to avoid this problem.
090729 15:07:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
090729 15:07:16 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\vm2003-relay-bin.000001' position: 4
090729 15:07:16 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Host 'VM2003' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400
090729 15:24:16 [Note] Slave I/O thread killed while connecting to master
090729 15:24:16 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4
090729 15:24:16 [Note] Error reading relay log event: slave SQL thread was killed
090729 15:25:18 [Note] Slave SQL thread initialized, starting replication in log 'log.000002' at position 98, relay log '.\vm2003-relay-bin.000001' position: 4
090729 15:25:18 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Host 'VM2003' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400
090729 15:27:18 [Note] Slave I/O thread killed while connecting to master
090729 15:27:18 [Note] Slave I/O thread exiting, read up to log 'log.000002', position 98
090729 15:27:18 [Note] Error reading relay log event: slave SQL thread was killed
090729 15:28:05 [Note] Slave SQL thread initialized, starting replication in log 'log.000001' at position 98, relay log '.\vm2003-relay-bin.000001' position: 4
090729 15:28:05 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Host 'VM2003' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400
090729 15:30:05 [Note] Slave I/O thread killed while connecting to master
090729 15:30:05 [Note] Slave I/O thread exiting, read up to log 'log.000001', position 98
090729 15:30:05 [Note] Error reading relay log event: slave SQL thread was killed
090729 15:30:18 [Note] Slave SQL thread initialized, starting replication in log 'log.000001' at position 98, relay log '.\vm2003-relay-bin.000001' position: 98
090729 15:30:18 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Host 'VM2003' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400
090729 15:31:18 [Note] Slave I/O thread killed while connecting to master
090729 15:31:18 [Note] Slave I/O thread exiting, read up to log 'log.000001', position 98
090729 15:31:18 [Note] Error reading relay log event: slave SQL thread was killed
090729 15:33:09 [Note] Slave SQL thread initialized, starting replication in log 'log.000002' at position 98, relay log '.\vm2003-relay-bin.000001' position: 4
090729 15:33:09 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Host 'VM2003' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400
090729 15:50:30 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown090729 15:51:09 [Note] Slave I/O thread killed while connecting to master
090729 15:51:09 [Note] Slave I/O thread exiting, read up to log 'log.000002', position 98
090729 15:51:09 [Note] Error reading relay log event: slave SQL thread was killed
090729 15:51:11 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3 user: 'root'090729 15:51:11 InnoDB: Starting shutdown...
090729 15:51:13 InnoDB: Shutdown completed; log sequence number 0 43655
090729 15:51:13 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete090729 15:51:13 InnoDB: Started; log sequence number 0 43655
090729 15:51:13 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=vm2003-relay-bin' to avoid this problem.
090729 15:51:13 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
090729 15:51:13 [Note] Slave SQL thread initialized, starting replication in log 'log.000002' at position 98, relay log '.\vm2003-relay-bin.000001' position: 98
090729 15:51:14 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Can't connect to MySQL server on '192.168.0.202' (10061)' errno: 2003 retry-time: 60 retries: 86400
090729 15:52:14 [Note] Slave I/O thread killed while connecting to master
090729 15:52:14 [Note] Slave I/O thread exiting, read up to log 'log.000002', position 98
090729 15:52:14 [Note] Error reading relay log event: slave SQL thread was killed
090729 15:53:37 [Note] Slave SQL thread initialized, starting replication in log 'log.000003' at position 98, relay log '.\vm2003-relay-bin.000001' position: 4
090729 15:53:37 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Host 'VM2003' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400
你在202上把对应进行复制的用户通过grant命令给予权限即可