Hallo ... I tried to create simple replication: 2 machines mysql-3.23.32 master - name register slave - nane proxy master configuration: [mysqld] set-variable = max_connections=300 log-bin server-id=1 slave configuration: [mysqld] master-host=register master-user=replicate_user master-password=++++++++++++ server-id=2 replicate-do-table=db1.tbl1 replicate-do-table=db1.tbl2 replicate-do-table=db1.tbl3 this is log from my slave: 010127 21:44:39 mysqld started /opt/mysql-3.23.32/libexec/mysqld: ready for connections 010127 21:44:42 Slave: connected to master 'replicate_user@register:3306', replication started in log 'FIRST' at position 4 010128 0:07:04 Error reading packet from server: Could not open log file (read_errno 0,server_errno=2) 010128 0:07:04 Slave: Failed reading log event, reconnecting to retry, log 'register-bin.004' position 86 010128 0:07:05 Slave: reconnected to master 'replicate_user@register',replication resumed in log 'register-bin.004' at position 86 010128 0:07:05 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 010128 0:08:05 Slave: Failed reading log event, reconnecting to retry, log 'register-bin.004' position 86 directly in this time ( when slave stoped replication) im restarting master #killall -HUP mysqld next interesting think is that .. when I started replication, I had on master 3 event logs (register-bin.001, register-bin.002, register-bin.001) and they were written in register-bin.index now (after restart) I have there only register-bin.001 (and only this one is in register-bin.index file) I thought my problem is same as in thread <[EMAIL PROTECTED]> so I tryied * cat /path/to/datadir/master.info * get the log name and the offset * start the slave server * CHANGE MASTER TO MASTER_LOG_POS=saved_position, MASTER_LOG_FILE='saved_log_name' but, in the master.info on slave machine was register-bin.004 86 which doesn't exist on master any more .... so I tryied to change it to the register-bin.001, position 1 and it didn't helped is there a possibility to start this replication ? or I must take a snap of master and start again from begin ? Jan Matis --------------------------------------------------------------------- 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
