Unanswered: how to combine two or more remote databases in one system database
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..
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.