How can I merge two databases?

Discussion in 'Databases' started by Turnkey Websites, Apr 5, 2007.

  1. #1
    Hello,

    I have two databases on my webserver lebphoto.com with the same tables. One with a 1665 members and the other with 33 members, I want to merge them together. is there a way other than typing each records by myself or ask the members to register again?

    Thank you
     
    Turnkey Websites, Apr 5, 2007 IP
  2. Clive

    Clive Web Developer

    Messages:
    4,507
    Likes Received:
    297
    Best Answers:
    0
    Trophy Points:
    250
    #2
    Import the 33 member list into the bigger one.

    Make sure "memberid" values do not duplicate. If you could tell us what script you're using I would be able to advise better about the best way of merging the two user bases.
     
    Clive, Apr 5, 2007 IP