Stop master and slave remove binary logs (hostname.001, hostname.002...) from master remove log index (hostname.index) from master remove master.info from the slave tar data on master untar on slave start master and slave
The directories of where the files reside would depend on the method of installation (binary, rpm, source) but if you can do a find or if you are on linux, locate would help. Regards, Bhavin. ----- Original Message ----- From: "David McInnis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 3:09 PM Subject: Mysql Replication > I am having a problem with replication. > > I had a master / slave environment set up and running successfully. I > then took the slave offline for a while and made substantial changes to > the master. > > Then I master copied the new database environment to the slave server by > taring the tables and copying them to the slave server. > > Then I restarted the slave and now my slave database is not working. > > Is there something that I need to do in order to resync the slave with > the new master? > > > David McInnis > > Not really an SQL or query question, but ... > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
