Merging Databases

Discussion in 'Integration' started by marrek, Mar 4, 2009.

  1. marrek

    marrek New Member

    Joined:
    Jan 31, 2009
    Messages:
    3
    Hi, i'm having a problem with merging databases. we had a dev db and a production db, which had a different number of users. ( on a Drupal installation)

    Now I want to merge the two, but i'm getting errors like
    " MYSQL ERROR:
    Duplicate entry '1662' for key 1
    in query:
    INSERT INTO radar2.users (uid, name,pass,mail, init, status,created,timezone) VALUES (1662, 'adfasdasdfasdf', '2a9bfb1a8870aa4787a9e90a5c51b665', 'mgmacken@hotmail.com', 'mgmacken@hotmail.com', '1', 1236176260, 0)

    "

    the uid 1662 was around the maximum # of users on the dev db. But now that we have 2000 users on the production db, this obviously won't work.

    The amember_members table has the correct # of users in it ( ~2000), so where is it getting 1662 from??

    mark
  2. marrek

    marrek New Member

    Joined:
    Jan 31, 2009
    Messages:
    3
    just a follow up, i get the same error if i try to rebuild db from amember

    mark

Share This Page