Aah, sorry, I didn't explain myself very well 8-( At the mysql prompt >RESET SLAVE;
This tells the slave to reset itself back, and forget the current settings (eg. the log position etc., not the master or such details) to where the master started and begin replication from there. There is also a complementary RESET MASTER which tells the master to get rid of all binary logs and start again. RESET SLAVE is documented here http://dev.mysql.com/doc/refman/5.0/en/reset-slave.html Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 1:49 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem Hello David, Reset how? I did the CHANGE MASTER TO and set it as what was specified from the Show Master command after I tar'd the files. Thanks! Brett >Hi Brett, > >Did you reset the master and/or slave? Looking at the logs, it appears >as though the slave is trying to read from a different position in the >log than the master has reached. > >Regards > > >--------------------------------------------------------------- >********** _/ ********** David Logan >******* _/ ******* ITO Delivery Specialist - Database >***** _/ ***** Hewlett-Packard Australia Ltd >**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] >**** _/ _/ _/ _/ **** Desk: +618 8408 4273 >**** _/ _/ _/_/_/ **** Mobile: 0417 268 665 >***** _/ ****** >****** _/ ******** Postal: 148 Frome Street, >******** _/ ********** Adelaide SA 5001 > Australia >i n v e n t >--------------------------------------------------------------- > >-----Original Message----- >From: Brett Harvey [mailto:[EMAIL PROTECTED] >Sent: Monday, 24 July 2006 1:36 PM >To: mysql@lists.mysql.com >Subject: Re: Replication Problem > >Hi, > >Thanks for the response. > >Yes - I have that in my config also. > >replicate-do-db=FMS > >Thanks > >Brett > >>Hi, >> >>Did u mention what all databases has to be replicated in ur cnf file >>as (replicate-do-db=database-name). >> >> >>Thanks & Regards >>Dilipkumar > >-- >----------------------------------------------------------------------- - >-------- >/Brett C. Harvey; >/Creative-Pages.Net, President; >/Facility Management Systems, CTO (www.fmsystems.biz); >/Lasso Partner Association Member ID #LPA135259 >(www.omnipilot.com/www.lassopartner.com); >----------------------------------------------------------------------- - >-------- > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- ------------------------------------------------------------------------ -------- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.fmsystems.biz); /Lasso Partner Association Member ID #LPA135259 (www.omnipilot.com/www.lassopartner.com); ------------------------------------------------------------------------ -------- -- 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]
