Answers.Body: <p>I think you are saying that you have a single database for CMS content on the old site and that you already have new CMS content in the database for the new site. I think you want to move the CiviCRM structure and data. If I have understood that correctly (it would be good if you clarified by editing the question) then you can do the following.</p>
  
  <p>1) split the CMS and CiviCRM databases: KEEP A BACKUP! Create a copy of the combined database by dump, rename the original and then reload). In the original you delete the CiviCRM tables (with e.g. phpMyAdmin) and in the copy, delete the WP tables. You need to edit the civicrm.settings.php to change the name of the CRM database - it will have the same username when created this way. This last bit allows you to keep access to the old CiviCRM so you can check things.</p>
  
  <p>2) on your new site, reinstall CiviCRM using the same version as the old site and the same database details. Now replace the CiviCRM database with the CiviCRM database from the old site. Have a look at the documentation first! <a href="https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-09T02:40:15.927Z
Answers.Text: Thanks a lot. I think it would work.
Answers.UserDisplayName: Ashok
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-20T08:45:59.243Z
Answers.Text: Hi @MickKahn, any Idea how long this process takes?
Answers.UserDisplayName: Grow
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-21T09:13:47.567Z
Answers.Text: If you mean to actually do the final run, then not much time at all, but you'll want to do various testing etc so that will take quite a bit of time to familiarise yourself. Testing and backup is essential!
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-08T09:37:45.280Z
Answers.LastActivityDate: 2019-05-08T09:37:45.280Z
Answers.UserDisplayName: Mick Kahn
Answers.Body: <p>There is now this solution that may help some folk <a href="https://lab.civicrm.org/extensions/configitems" rel="nofollow noreferrer">https://lab.civicrm.org/extensions/configitems</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-08-09T22:38:36.917Z
Answers.LastActivityDate: 2024-08-09T22:38:36.917Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I am recreating my website on another server. So my big concern is how to move all CRM data to new server/website.
  To do separately exporting/importing contacts, membership, activities etc. is not so much accurate way, because there is a possibility of missing something.</p>
  
  <p>Also I can't dump whole database. Is there any possible method, how can I do this??</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-08T07:30:27.183Z
Comments.Text: Welcome to CiviCRM SE. Why can't you do a database dump? That is certainly the best approach?
Comments.UserDisplayName: Mick Kahn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-08T07:44:41.510Z
Comments.Text: New website has its separate database, content etc.
Comments.UserDisplayName: Ashok
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-08T08:16:52.997Z
Comments.Text: Sounds like you are trying to merge some of the old with some of the new.  Please edit your question and describe what databases your current site has, what the new one has and what data from each one you are wanting to keep.
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-08T08:42:06.547Z
Comments.Text: Both of the websites are built on WordPress. I just want to import all CiviCRM data into new website's database.
Comments.UserDisplayName: Ashok
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-08T10:00:52.733Z
Comments.Text: Ok, but do you have one database for both WordPress and Civi, or do they have separate db's?
Comments.UserDisplayName: Aidan
Tags: <database>
Title: How to Export/Import all CiviCRM data from one website to another one
ThreadText: # How to Export/Import all CiviCRM data from one website to another one
  
  (Asked by: username_0 on 2019-05-08)
  
  I am recreating my website on another server. So my big concern is how to move all CRM data to new server/website.
  To do separately exporting/importing contacts, membership, activities etc. is not so much accurate way, because there is a possibility of missing something.
  
  Also I can't dump whole database. Is there any possible method, how can I do this??
  
  **Tags:** database
  
  > **Comments:**
  > **username_1**: Welcome to CiviCRM SE. Why can't you do a database dump? That is certainly the best approach?  
  > **username_0**: New website has its separate database, content etc.  
  > **username_2**: Sounds like you are trying to merge some of the old with some of the new.  Please edit your question and describe what databases your current site has, what the new one has and what data from each one you are wanting to keep.  
  > **username_0**: Both of the websites are built on WordPress. I just want to import all CiviCRM data into new website's database.  
  > **username_2**: Ok, but do you have one database for both WordPress and Civi, or do they have separate db's?  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-05-08. Score: 2 | Accepted answer
  
  I think you are saying that you have a single database for CMS content on the old site and that you already have new CMS content in the database for the new site. I think you want to move the CiviCRM structure and data. If I have understood that correctly (it would be good if you clarified by editing the question) then you can do the following.
  
  1) split the CMS and CiviCRM databases: KEEP A BACKUP! Create a copy of the combined database by dump, rename the original and then reload). In the original you delete the CiviCRM tables (with e.g. phpMyAdmin) and in the copy, delete the WP tables. You need to edit the civicrm.settings.php to change the name of the CRM database - it will have the same username when created this way. This last bit allows you to keep access to the old CiviCRM so you can check things.
  
  2) on your new site, reinstall CiviCRM using the same version as the old site and the same database details. Now replace the CiviCRM database with the CiviCRM database from the old site. Have a look at the documentation first! <https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/>
  
  > **Comments:**
  > **username_0**: Thanks a lot. I think it would work.  
  > **username_3**: Hi @MickKahn, any Idea how long this process takes?  
  > **username_1**: If you mean to actually do the final run, then not much time at all, but you'll want to do various testing etc so that will take quite a bit of time to familiarise yourself. Testing and backup is essential!  
  
  ---
  
  ### Answer by username_4 on 2024-08-09. Score: 0
  
  There is now this solution that may help some folk <https://lab.civicrm.org/extensions/configitems>
  
  
  ---
  
  