Click here to Skip to main content
15,891,136 members
Search within:


Create a insert trigger to insert the same record into diffrent server (remote server)
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello

Using MySQL, I have DB 1 with table T1 on Server 1 and DB 2 with table T1 on Server 2. Not on the same network and T1 contain the same columns with the same datatypes.

I want to create a trigger on DB 1 so when there is a insert on T1 on DB 1, all the data inserted in T1 is copied (or inserted) into T1 but the T1 that is on DB 2 on Server 2.



Guys Can u plz help me if it is possible
Posted
Updated 22-Jul-13 1:35am
v3
Add a Solution

1 solution

Suggest following option, using the batch script, you need to export the data from T1/Server1 and import into T1/Server2

export and import can be done using mysqldump command.

Batch script can be executed using a cron job with the required frequency (daily / hourly etc)
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to insert rows to table ( control a condition by trigger)
Updating multiple records after insert with a trigger
How to create trigger on database insert
How do I make a trigger in SQL SERVER which insert a record in Oracle Database
Insert multiple records using trigger
Trigger to Insert or Update
Trigger For a bulk insert
Insert trigger
I have created trigger for after insert now how to do for update with in same trigger
How to insert records into one server database when records inserted in the another Server Database

Advertise
Privacy
Cookies
Terms of Use
Last Updated 24 Jul 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900