how to combine two or more remote databases in one system database

rajasekhar1242 · #1 (**permalink**) 03-10-09, 02:48

hi everyone,
i have one database in my system. till now i can access any remote database.
but now i have to combine all remote databases in my system database. that is i want to maintain that combined database. is it possible?? pls give me a valuable reply..

aschk · #2 (**permalink**) 03-10-09, 07:34

Do you want to import all the tables into 1 database?

rajasekhar1242 · #3 (**permalink**) 03-11-09, 03:44

yes, i want to get all the tables from all the remote databases into one mysql database.
one more thing is " i am using trigger concept to get a changes in remote
database from another database" but trigger concept is working in my system database only. not in other remote database.

aradapilot · #4 (**permalink**) 03-11-09, 12:43

If you only want to keep one copy of the data and just have local access for convenience, which it sounds like you might...check out Federated tables at MySQL :: MySQL 5.1 Reference Manual :: 13.10.1 FEDERATED Storage Engine Overview

Internet Services

Web Development

Digital Marketing

Consumer Tech