Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    4

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

    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..

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Do you want to import all the tables into 1 database?

  3. #3
    Join Date
    Mar 2009
    Posts
    4
    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.

  4. #4
    Join Date
    Feb 2009
    Location
    Rutherford, NJ
    Posts
    9
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •