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]
