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: [email protected]
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: [email protected]
>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: [email protected]
>>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]
