How to export/import Civi CRM all database (profile, custom field, contacts etc) with same setting in WordPress?

  • Hi Rajesh - could you explain what you are trying to do, that would help in trying to answer your question. If you are moving from one server to another - there is a solution for that - if you are moving to another CRM - there is a solution for that too.
    – themak
    May 13 '19 at 16:06

Welcome to StackExchange Rajesh! The simplest option is to dump and load the database (eg using mysqldump). If you need something different, edit your question to provide more information.


If you are switching your cms from drupal/joomla to wordpress then there are instructions here. https://docs.civicrm.org/sysadmin/en/latest/misc/switch-cms/

If you are wanting to "clone" an existing set up using mysqldump there is a perl script that you will want to run to remove the "definer": statements.

perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g' /path/to/mysqldump.sql

More info on this thread.

Why do I get "Access denied; you need (at least one of) the SUPER privilege(s) for this operation" when importing a SQL dump to CiviCRM?

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.