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', '1
>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 Tr
om Freeradius.
I have 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
>>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
ortune wrote:
>
> Hi,
>
> On Mon, Dec 8, 2008 at 9:20 AM, Marcel Grandemange
> wrote:
> >>WHat errors are you getting when you try and start the slave?
> >
> > That's the exact thing
> >
> > mysql> show slave status\G
> > **
>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 dat
