0

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??

  • Welcome to CiviCRM SE. Why can't you do a database dump? That is certainly the best approach? – Mick Kahn May 8 at 7:30
  • New website has its separate database, content etc. – Ashok May 8 at 7:44
  • 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. – Aidan May 8 at 8:16
  • Both of the websites are built on WordPress. I just want to import all CiviCRM data into new website's database. – Ashok May 8 at 8:42
  • Ok, but do you have one database for both WordPress and Civi, or do they have separate db's? – Aidan May 8 at 10:00
1

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/

  • Thanks a lot. I think it would work. – Ashok May 9 at 2:40

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.