Re: Firing an On Insert Trigger from Server A to Server B

[uwe resch]

you need 3 tables:

like this:
on server A

CREATE TABLE `dbnam1`.`test` (
`ID` int(11) NOT NULL,
`data` text,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

on server B

CREATE TABLE `dbnam2`.`test` (
`ID` int(11) NOT NULL,
`data` text,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1



and a second one on server A wich links to the table on server B

CREATE TABLE `testfed` (
`ID` int(11) NOT NULL,
`data` text,
PRIMARY KEY (`ID`)
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://username2:password456@192.168.5.5:3306/dbnam2/test'

now create your trigger to copy from test to testfed and the data will bi insert into your test table from dbnam 2