Answers.Body: <p>Welcome to StackExchange Rajesh!  The simplest option is to dump and load the database (eg using <code>mysqldump</code>).  If you need something different, edit your question to provide more information.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-07T07:52:04.290Z
Answers.LastActivityDate: 2019-05-07T07:52:04.290Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>If you are switching your cms from drupal/joomla to wordpress then there are instructions here. <a href="https://docs.civicrm.org/sysadmin/en/latest/misc/switch-cms/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/misc/switch-cms/</a> </p>
  
  <p>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.</p>
  
  <pre><code>perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g' /path/to/mysqldump.sql
  </code></pre>
  
  <p>More info on this thread.</p>
  
  <p><a href="https://civicrm.stackexchange.com/questions/619/why-do-i-get-access-denied-you-need-at-least-one-of-the-super-privileges-f">Why do I get &quot;Access denied; you need (at least one of) the SUPER privilege(s) for this operation&quot; when importing a SQL dump to CiviCRM?</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-14T20:55:04.783Z
Answers.LastActivityDate: 2019-05-14T23:13:13.223Z
Answers.LastEditDate: 2019-05-14T23:13:13.223Z
Answers.UserDisplayName: Luke Stewart
Body: <p>How to export/import  Civi CRM  all database  (profile, custom field, contacts etc) with same setting in WordPress?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-13T16:06:32.747Z
Comments.Text: 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.
Comments.UserDisplayName: themak
Tags: <wordpress>
Title: How to export/import Civi CRM?
ThreadText: # How to export/import Civi CRM?
  
  (Asked by: username_0 on 2019-05-07)
  
  How to export/import Civi CRM all database (profile, custom field, contacts etc) with same setting in WordPress?
  
  **Tags:** wordpress
  
  > **Comments:**
  > **username_1**: Hi username_0 - 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.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2019-05-07. Score: 3
  
  Welcome to StackExchange username_0! 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.
  
  
  ---
  
  ### Answer by username_3 on 2019-05-14. Score: 1
  
  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?](https://civicrm.stackexchange.com/questions/619/why-do-i-get-access-denied-you-need-at-least-one-of-the-super-privileges-f)
  
  
  ---
  
  