Hi Brett,
Just about to go when your email rocked up 8-) Like you, I can't see any
reason why it is not replicating according to the logs.
Have you tried to create a database on the master and see if it appears
on the slave? What commands are being replicated at this time? You can
use the mysqlbinlog command to check the binary log to see what it is
trying to replicate. There are certain commands that are not replicated
and we want to eliminate those from the equation.
Try the create database command eg.
On master
>CREATE DATABASE THING;
On Slave
>SHOW DATABASES;
You should see the database thing on your slave. You can then drop the
database on the master and it should disappear.
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 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
mysql> show master status\g
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| FMSweb-bin.000001 | 903763 | | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: xxx.xxx.xxx.xxx
Master_User: FMSReplicate
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: FMSweb-bin.000001
Read_Master_Log_Pos: 903763
Relay_Log_File: FMSbuilding-relay-bin.000004
Relay_Log_Pos: 901275
Relay_Master_Log_File: FMSweb-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: FMS
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 903763
Relay_Log_Space: 901275
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.00 sec)
Gnite to you! lol I just got up...
Thanks!
Brett
>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.
--
------------------------------------------------------------------------
--------
/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]
