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);
--------------------------------------------------------------------------------
