RE: Replication troubles

2003-06-13 Thread Andrew Braithwaite
>In the case of both the master and the slave the max_allowed_packet is set to 1047552. In both cases I raised it to 2047552 just to be generous. In order for changes to the max_allowed_packet to take effect, you'll need to restart mysqld on that server. Cheers, Andrew -Original Message

Re: Replication troubles

2003-06-13 Thread Nils Valentin
Hi Bruce, I dont know the solution, but error 1236 is a server issue as described below. Starting and stopping the slave wont help anything. Are you sure that the servers binary log is not corrupted ? Try to reset the master. 4.10.7.5 RESET MASTER (master) Deletes all binary logs listed in

Re: Replication troubles

2001-03-26 Thread Jeremy D . Zawodny
On Mon, Mar 26, 2001 at 09:02:59AM -0800, Bryan Coon wrote: > > Just a follow up- I got replication working, the error was (as > usual) simple... in the MySQL Replication HOWTO, it says 'Add the > following to my.cnf on the slave(s): I of course (:P) put them at > the end of the file, they must g

RE: Replication troubles

2001-03-26 Thread Bryan Coon
ssage- From: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 3:30 AM To: Bryan Coon Cc: [EMAIL PROTECTED] Subject: Re: Replication troubles On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote: > I have two machines which I am trying to set up replicatio

Re: Replication troubles

2001-03-25 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote: > I have two machines which I am trying to set up replication on. I followed > the howto as describe in the manual, and everything seemed to be okay (i.e. > no errors), but it simply doesn't work. > > Heres what I did on the master: > 1