Re: Problems with replication restarting

2004-12-20 Thread Ian Sales
[EMAIL PROTECTED] wrote: However, when I restart the slave (through init scripts, or when rebooting the server etc.), instead of continuing on from where it left off, it appears to start again from the beginning. This is confirmed by watching the value of Relay_Log_Pos from SHOW SLAVE STATUS\G.

RE: Problems with replication restarting

2004-12-20 Thread mark_round
PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Problems with replication restarting [EMAIL PROTECTED] wrote: However, when I restart the slave (through init scripts, or when rebooting the server etc.), instead of continuing on from where it left off, it appears to start again from the beginning

RE: Problems with replication restarting

2004-12-20 Thread Sanjeev Sagar
MySQL version or release on what O/S? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: RE: Problems with replication restarting So this would imply that you cannot simply stop/start a slave server

Re: Problems with replication restarting

2004-12-20 Thread Jon Drukman
[EMAIL PROTECTED] wrote: So this would imply that you cannot simply stop/start a slave server - instead, I would need to write a wrapper script that stops the slave using STOP SLAVE, and at next startup, read the master.info file to find out where it left off, and then issue a CHANGE MASTER TO...