Hi Brett,
I am absolutely baffled as to how the binlog/relaylog can be updated but
the dbs/tables etc. are not being touched. The only other thing is to
check the datadir on your server. Is it actually pointing to where you
think it is?
You can do a
>SHOW VARIABLES LIKE 'datadir';
and check it is pointing to where you think it should be.
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: Tuesday, 25 July 2006 9:19 AM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
Thanks for attempting to help.
When I look at my show slave status, its updating. When I look at
the FMSbuilding-relay-bin, its updating! It has the information
that's taken place on the master server. I can see information in
the FMSbuilding-relay-bin on the slave server that I did on the
master. But, the databases/tables/data on the slave are not being
updated.
Brett
>I am a little bit lost as to why this is happening. The only suggestion
>I have at this point is to go through the replication troubleshooting
in
>this chapter and see if something there is causing the problem. Looking
>at what you have done and the docs, I don't think this will help. This
>may be a bug. Sorry I can't be of more assistance.
>
>http://dev.mysql.com/doc/refman/5.0/en/replication.html
>
>I did find this in the bug system, you may be able to either re-open it
>or log a new one
>
>http://bugs.mysql.com/bug.php?id=10157
--
------------------------------------------------------------------------
--------
/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]
