In the last episode (Jul 07), Marcel Grandemange said:
I hope someone can assist me. I have a freeradius server running off
mysql. Now I would like to use triggers to negate some of the traffic
logged within it. I tried to use following as trigger..
Create Trigger ftp
BEFORE UPDATE
Good Day once again.
Im needing assistance again with triggers!
Create Trigger hostchange
BEFORE UPDATE ON host
FOR EACH ROW
BEGIN
IF NEW.status != OLD.status THEN
use smsgw;
insert into outbox (number, insertdate, text, phone, dreport) VALUES
('0836075144', '', 'HostDown', '1',
managed to get triggers working to a separate db altogether but not
from the same db to the same db.
What am I doing wrong?
Regards.
Marcel Grandemange
wrote:
Hi,
On Mon, Dec 8, 2008 at 9:20 AM, Marcel Grandemange
thavi...@thavinci.za.net wrote:
WHat errors are you getting when you try and start the slave?
That's the exact thing
mysql show slave status\G
*** 1. row
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
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
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
