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 status\G;
regards anandkl On Mon, Mar 8, 2010 at 6:46 PM, Steven Staples <sstap...@mnsi.net> wrote: > I don't have the error anymore, but the slave will start, but when you show > slave status, it shows that there is a failure, and the failure was, a > duplicate primary key. > > What i did to fix/bandaid it, was i truncated the table on the slave, and > restarted the slave again... then i did a delete on the master, where ID < > XXXX. > > > > > 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 the output of SHOW SLAVE STATUS? > > JW > > On Fri, Mar 5, 2010 at 10:11 AM, Steven Staples <sstap...@mnsi.net> 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 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 > > been fine for the last week... until today. > > > > We stopped the mysql process on the slave, and did a backup (due to size, > > we > > just rsync and backup the rsync) of the table files. Took about 40 > minutes > > to do (still not sure why it was that long, but anyway), and then we > > restarted the slave mysql. We're getting an error now. Apparently one > of > > the tables is out of sync now? What appears to have happened, is that > > when > > the slave was down, i truncated a table on the master. > > > > I've read that this sometimes causes errors, is this a bug? Or a is there > > something I should do differently? > > > > > > Steven Staples > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=joh...@pixelated.net > > > > > > > -- > ----------------------------- > Johnny Withers > 601.209.4985 > joh...@pixelated.net > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.733 / Virus Database: 271.1.1/2711 - Release Date: 03/05/10 > 02:34:00 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=anan...@gmail.com > >
