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