Results 1 to 2 of 2

Thread: How to merge 2 MySQL dbs

  1. #1
    ProxySites.ca's Avatar
    ProxySites.ca is offline Newbie Net Builder
    Join Date
    Jul 2009
    Location
    ProxySites.ca
    Posts
    241
    Thanks
    29
    Thanked 3 Times in 3 Posts

    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?

    TIA
    Proxy Sites

  2. #2
    RedPhoenix's Avatar
    RedPhoenix is offline Unknown Net Builder
    Join Date
    Sep 2009
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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
    B..table_X'.

    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, 19: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, 09:52 AM
  4. ProxySites.ca and Juvos.com Merge!
    By ProxySites.ca in forum Web Proxies
    Replies: 20
    Last Post: 10 September, 2009, 04:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

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