Re: Restarting slave after interruption

2008-05-24 Thread Moon's Father
This is a classic error. You just reconfigurate the parameter master_log_file and master_log_pos .Good luck. On Fri, May 23, 2008 at 5:13 AM, Mike [EMAIL PROTECTED] wrote: On Thu, May 22, 2008 at 10:41 AM, François Beausoleil [EMAIL PROTECTED] wrote: Hi all! I must be stupid or

Re: Restarting slave after interruption

2008-05-24 Thread François Beausoleil
Thanks Mike! Le 2008-05-22 à 17:13, Mike a écrit : If your taking a dump of the master open two windows. Don't close either In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; master status; Then in the second window procedure with mysqldump. The exact syntax was FLUSH

Restarting slave after interruption

2008-05-22 Thread François Beausoleil
Hi all! I must be stupid or something. I can't find what my problem is. I searched this list, and did find a couple of hits, but nothing that seemed fully relevant. This one in particular was interesting: http://lists.mysql.com/mysql/212863 I have a single master (server-id=1) and a

Re: Restarting slave after interruption

2008-05-22 Thread Mike
On Thu, May 22, 2008 at 10:41 AM, François Beausoleil [EMAIL PROTECTED] wrote: Hi all! I must be stupid or something. I can't find what my problem is. I searched this list, and did find a couple of hits, but nothing that seemed fully relevant. This one in particular was interesting: