I have a production MySQL server, and another server used for setting as slave to the MySQL server. I have go thru the step below:
At MASTER:
1) Flush tables with read lock
2) tar the /usr/local/mysql/var, as snapshoot of the current db
3) delete the log file (001..002.... index)
4) unlock tables
5) stop , and start the MySQL
Then,
At Slave:
1) untar the snapshoot
2) remove the log file
3) start MySQL
I check the error file, it keep on return me:
021010 17:49:03 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (server_errno=65535)
Failed reading log event, reconnecting to retry, log 'sbs104-bin.001' position 2482790
021010 17:49:03 Slave: reconnected to master 'replicate@192.1.1.1:3306',replication resumed in log 'sbs104-bin.001' at position 2482790
Please advice.