my solution for this problem 1. Please you look status salve on the mysql with syntax mysql> show slave status
2. After that, please you look Log_File on column, what a name file ? 3. Please you open your shell this file with mysqlbinlog "file_name" | more 4. please you find the position (24655608), i think can not found data he..he. Dont worry, please you find again with your guess "near position", example : 246556xx 5. last action after you can found the data, please change position on your slave okay, i hope this can help you im sorry i will go home now... :), maybe next week we could meet again =-hery=- ----- Original Message ----- From: "Charitha" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 5:57 PM Subject: Replication problem > > > Hello all, > > I am trying to replicate the database in two machines with one master and > one slave. I was having the my.cnf entry in the master with the following > lines: > > log-bin= /var/lib/mysql/replication1.log > server-id=1 > > > It was working very fine until yesterday evening. > But suddenly there was an error and i found in the mysqld.log file with > the error > > 020201 16:06:32 Slave: connected to master > '[EMAIL PROTECTED]:3306', replication started in log > 'replication1.log' at position 24655608 > 020201 16:06:32 Error reading packet from server: Could not find first > log (read_errno 0,server_errno=65535) > 020201 16:06:32 Slave: Failed reading log event, reconnecting to retry, > log 'replication1.log' position 24655608 > 020201 16:06:32 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log > 'replication1.log' at position 24655608 > 020201 16:06:32 Error reading packet from server: Could not find first > log (read_errno 0,server_errno=65535) > > > I thought that the error was due to the replication file name and i > changed the entry in my.cnf file as follows. > > log-bin= /var/lib/mysql/replication4.log > server-id=1 > > > And now it is again started working. > Well! I want to know whethere there is some bound that replication could > not be continued after that. > > Please immediate reply is wanted ....... > > Thank you one and all. > > -- > Regards, > Charitha. C. > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
