>WHat errors are you getting when you try and start the slave?
That's the exact thing....
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.11.252
Master_User: cjcrepl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000005
Read_Master_Log_Pos: 98
Relay_Log_File: gw2-relay-bin.000099
Relay_Log_Pos: 235
Relay_Master_Log_File: mysql-bin.000005
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: cjcd0,cjcd0
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: 98
Relay_Log_Space: 235
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)
According to the slave all is running and 100%, although the data is visibly
outdated.
And updates to tables or even new tables do not replicate since connectivity
loss..
>What does the error log say?
> Good Day.
>
> Im wondering if someone can assist me.
>
> Ive been using replication for a while now and it tends to fail very
> easily.
>
> One of my sites lost connectivity for a while and when it came back
> obviously replication broke again.
>
> How can I get it to populate all data from master again?
>
> Load data from master; is being depreciated and doesn't really work
> anyhow.
> I do not wish to create dump and do this manually every time it fails.
>
>
> Advise?
>
> Also is replication really this unreliable? It breaks at the slightest
> hiccup...
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> ______________________________________________
> This email has been scanned by Netintelligence
> http://www.netintelligence.com/email
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
