No, I don't see sny errors when running SHOW SLAVE STATUS. How should I found out if the slave dropped and created the tables again?
Basically, if everything works fine, do I need to do anything in such a case (cleaning master log file, resetting the log position, etc?) Thanks, -Jalil > -------- Original Message -------- > Subject: Re: Need help w/ re-starting Replication > From: Atle Veka <[EMAIL PROTECTED]> > Date: Fri, April 29, 2005 5:20 pm > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > > On Fri, 29 Apr 2005 [EMAIL PROTECTED] wrote: > > > > > I set up replication and it was working fine but I re-created my master > > database (droped and created empty tables) and now my replication > > doesn't work. I checked the status of master and slave and they think > > they are in sync but when I add a new record to master I don't see it > > in slave. It used to work fine. > > > > Is there anyway to clean the binary log files and positions master and > > slave use and start the sync process again? > > Have you checked the slave to see if it dropped and created the table? > Does 'SHOW SLAVE STATUS\G' show any errors? > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]