We are using CiviCRM with Wordpress and would like to switch it to Drupal. I have created a fresh Drupal/CiviCRM install and gave CiviCRM it's own database. How do I go about transferring the data from the old Wordpress site to the new Drupal site?


1 Answer 1


Assuming that a) you gave CiviCRM a separate database under Wordpress, and b) you installed the same version of CiviCRM under Drupal:

  • Dump the current CiviCRM database to a .sql file.
  • Load that database into Drupal.
  • Review "Moving an Existing Installation to a New Server or Location" for relevant details regarding deleting caches etc.
  • Delete all the entries out of the civicrm_uf_match table in the CiviCRM database (while logged in as user 1).
  • Go to Administer menu > Users and Permissions > Synchronize Users to Contacts.

That should repopulate your civicrm_uf_match table and thus connect your Drupal users to contacts. Log out and log in again (in a different browser) to make sure everything looks good - and clear your caches again!

  • 1
    Hi. Thanks for the answer. Yes Wordpress has it's own Civi database and it's the same version as Drupal. Unfortunately, when I try to import the Wordpress database into Drupal, I get this error: [ERROR in query 7] Access denied; you need (at least one of) the SUPER privilege(s) for this operation. What does that mean? Apr 16, 2015 at 17:01
  • Also, when you say "Dump" do you mean export via phpMyAdmin (or Sequel Pro)? Apr 16, 2015 at 17:19
  • Yeah, export via the tool of your choice - phpMyAdmin works! As for the error - that really deserves its own question, so I posted the question (and answer) here: civicrm.stackexchange.com/questions/619/… Apr 16, 2015 at 18:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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