Hi
I want to copy MySQL table data hosted on Server A to a MySQL Table hosted on Server B.
I want to use an on insert Triggers on the MySQL table on Server A which will then insert the same row in an identical MySQL table on Server B.
For data backup and auditing purposes.
**********************************************************************************
Server A - Details
IP - 205.168.5.45
Database Name - dbnam1
User Name - username1
Password - password123
Table Name - test
**********************************************************************************
Whenever a record is inserted in table 'test' hosted on 205.168.5.45 ( Server A ), an on insert trigger will fire which inserts the same values into table 'test' hosted on 192.168.5.5 ( Server B ).
**********************************************************************************
Server B - Details
IP - 192.168.5.5
Database Name - dbnam2
User Name - username2
Password - password456
Table Name - test
**********************************************************************************
Using MySQL Triggers is this possible?
Please guide me.
Thanks in advance.
Regards
Meher Bala
http://www.opensourcevarsity.com
Edited 1 time(s). Last edit at 04/25/2011 12:16PM by Meher Bala.