At the moment I've got 2 drupal 7 site. Now I want to merge those two sites together. If I export the user table in the database from one site and import the data directly into another site, will that be working? Btw, The users don't have any related contents like nodes or comments in the site so I guess the only table I need to worry about the user table. The only concern is the password. I'm not sure if I import the data the user password will be the same.

2 Answers 2


I can think of a few problems that might occur if you simply import the users table:

  • Existing Users' IDs might overlap with the users to be imported (which would just give a SQL error about duplicate primary keys).
  • No way to add roles to the imported users (if applicable).
  • Imported Users' language might not exist on the new site.
  • Imported Users' theme might not exist on new site.
  • Likely many others

You're much better off using something like User Import to do this.

  • Thanks for the answer Adam. The user permission in my site is quite limited that registered user can only view some specific contents. About the user ID, I can simply change the ID to avoid the conflicts. Just tried export and import the SQL, it seems that it's working as expected.
    – ylzyh
    Commented Jan 20, 2014 at 2:09

You need to use Drupal-to-Drupal data migration module. Project page says

"With migrate_d2d 2.1, we are introducing a wizard-based UI for defining your Drupal-to-Drupal migrations. Enabling the migrate_d2d_ui module will add an "Import from Drupal" subtab to the Migrate dashboard - visit that tab, enter the credentials for your source Drupal database (versions 5, 6, or 7), and follow the steps to define how your legacy content maps to the destination Drupal 7 site."

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.