Hi Brett, Can you please do the following :
>SHOW MASTER STATUS; (on the master) and >SHOW SLAVE STATUS; (on the slave) Thanks P.S I will be going to bed soon so don't worry if you don't hear anything, I'll look at it first thing in the morning. --------------------------------------------------------------- ********** _/ ********** 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 9:28 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem Dave, I tried reset slave as you mentioned - no change. Nothing updating. Same error. Brett >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] -- ------------------------------------------------------------------------ -------- /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]