MySQL Forums
Forum List  »  Triggers

Firing an On Insert Trigger from Server A to Server B
Posted by: Meher Bala
Date: April 25, 2011 04:14AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Firing an On Insert Trigger from Server A to Server B
3020
April 25, 2011 04:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.