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]