Results 1 to 2 of 2

Thread: How to merge 2 MySQL dbs

  1. #1
    Join Date
    Jul 2009

    How to merge 2 MySQL dbs

    Hey Guys,

    I am trying to figure out how to merge 2 different MySQL databases from 2 different topsites to one.

    Is there a way this can be done?

    Proxy Sites

  2. #2
    If you mean 'insert all rows from a table in database A into an
    indetical table in database B', then yes.

    If both databases are in the same server, just do a direct 'insert A..table_X select * from

    If they're in different servers, you must create a prroxy table first, and then you basically do the same.

    You can generate the required SQL statements by querying sysobjects directly.

Similar Threads

  1. how to merge 2 DB ?
    By SonnyCooL in forum Databases
    Replies: 1
    Last Post: 15 November, 2010, 20:50 PM
  2. Merge
    By darkly in forum Community Building
    Replies: 3
    Last Post: 28 March, 2010, 14:35 PM
  3. Replies: 4
    Last Post: 23 January, 2010, 10:52 AM
  4. and Merge!
    By in forum Web Proxies
    Replies: 20
    Last Post: 10 September, 2009, 04:07 AM

Tags for this Thread


Posting Permissions

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