RE: Master/Slave - trucate master table

2010-03-08 Thread Steven Staples
to:anan...@gmail.com] Sent: March 8, 2010 11:45 AM To: Steven Staples Cc: Johnny Withers; mysql@lists.mysql.com Subject: Re: Master/Slave - trucate master table did u stop the slave process before stopping mysql on slave. Did u do the below before stopping the mysql on slave? slave stop; show slave sta

Re: Master/Slave - trucate master table

2010-03-08 Thread Ananda Kumar
XXX. > > > > > Steven Staples > > > -Original Message- > From: Johnny Withers [mailto:joh...@pixelated.net] > Sent: March 5, 2010 1:11 PM > To: Steven Staples > Cc: mysql@lists.mysql.com > Subject: Re: Master/Slave - trucate master table > > Does START SLA

RE: Master/Slave - trucate master table

2010-03-08 Thread Steven Staples
te on the master, where ID < . Steven Staples -Original Message- From: Johnny Withers [mailto:joh...@pixelated.net] Sent: March 5, 2010 1:11 PM To: Steven Staples Cc: mysql@lists.mysql.com Subject: Re: Master/Slave - trucate master table Does START SLAVE fail? If so, what is th

Re: Master/Slave - trucate master table

2010-03-05 Thread Johnny Withers
Does START SLAVE fail? If so, what is the output of SHOW SLAVE STATUS? JW On Fri, Mar 5, 2010 at 10:11 AM, Steven Staples wrote: > Good day everyone... > > I am working with a master/slave set up, and of course, we started it once > the database tables were a combined size of 60gb+ > > We've g

Master/Slave - trucate master table

2010-03-05 Thread Steven Staples
Good day everyone... I am working with a master/slave set up, and of course, we started it once the database tables were a combined size of 60gb+ We've got it running and in sync now, (stopped the master, deleted the bin files, rsync'd the database tables and restarted the master) and all has bee