I have a master and slave server, both running mysql-3.23.29-gamma. When I set up a second slave running mysql-3.23.33, it logged these errors: 010304 10:18:50 mysqld started /opt/local/mysql/libexec/mysqld: ready for connections 010304 10:18:51 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 0 010304 10:18:51 Error reading packet from server: Could not open log file (read_errno 0,server_errno=2) I notice that the file name is missing in the status display: mysql> show slave status; +------------------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos || Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | |Skip_counter | +------------------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+ | master.cc.umanitoba.ca | replic | 3306 | 60 | | 4 || Yes | | | 0 | | 0 | | +------------------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+ 1 row in set (0.00 sec) I had to do this to fix it: mysql> change master to master_log_file='master-bin.197'; Query OK, 0 rows affected (0.01 sec) The error log now said: 010304 10:39:48 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'master-bin.197' at position 0 Should this be necessary? Is there a bug someplace? -- -Gary Mills- -Unix Support- -U of M Academic Computing and Networking- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
