做MYSQL数据库同步时出错。高分在线等。不够再加分!!!
mysql> show slave status;
+---------------+-------------+-------------+---------------+-----------------+---------------------+-----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
| Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space |
+---------------+-------------+-------------+---------------+-----------------+---------------------+-----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
| 192.168.37.188 | root | 3306 | 60 | | 4 | SERVER-relay-bin.005 | 4 | | No | Yes | | | 0 | | 0 | 0 | 4 |
+---------------+-------------+-------------+---------------+-----------------+---------------------+-----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
mysql> slave start; 后,| 192.168.37.188 | root | 3306 | 60 | | 4 | SERVER-relay-bin.005 | 4 | | Yes | Yes | | | 0 | | 0 | 0 | 4 |
以下是出错信息:
050726 11:35:59 Slave I/O thread: connected to master 'root@192.168.37.188:3306', replication started in log 'FIRST' at position 4
050726 11:35:59 Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236)
050726 11:35:59 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
050726 11:35:59 Slave I/O thread exiting, read up to log 'FIRST', position 4
配置文件:
master:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
slave:
[mysqld]
log-bin
server-id=2
sql-bin-update-same
master-host=192.168.37.188
master-user=root
master-password=password
master-connect-retry=60
log-slave-updates
好象没有得到服务器的日志文件。很着急啊。在线等。不够分再加!!!多谢!!