Import/export database from old CRM version(5.4.0) to New CRM version(5.15.2) in wordrpess

Question

Currently I am using Civi CRM (5.4.0) and want to upgrade it. I downloaded new version and installed it in my wordpress website.

I had a separate database for CiviCRM. When I installed & activated new version CRM plugin, it created tables in existing wordpress database.

Now my concern is, how can I import contacts, custom fields, Profiles etc. in new CiviCRM. Old plugin had civicrm.settings.php for database connectivity but same not found in new one.

Answer 1

Ashok welcome to CiviCRM stackexchange

If you new CiviCRM database has not gone live than i would

1. Create a test instance of CRM 5.4.0
2. Upgrade CiviCRM to 5.15.2
3. Dump the Civi database after upgrade.
4. Drop the Civi database or all civi table from CiviCRM database i.e linked to your new Wordpress.
5. Import the CiviCRM database that was dumped at #3
6. Open CiviCRM from UI.
7. Clear CiviCRM cache by navigating to Administer >> System Settings >> Cleanup Caches and Update Paths.
8. Rebuild trigger by running http://domain.orn/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&triggerRebuild=1

If you don't like above approach then you can use extension that migrates settings from one site to another

1. Config Items - This tool supports adding and updating using json method ContactTypes, MembershipTypes, RelationshipTypes, OptionGroups with OptionValues, Groups, Tags, FinancialAccounts, FinancialTypes, EventTypes, ActivityTypes, LocationTypes, CaseTypes, CustomGroups with CustomFields, CiviCRM Settings (system settings set through the Setting.API - be especially careful with that!)

2. MI Data quality Tools - This tool supports adding and updating using json method ContactTypes, MembershipTypes, RelationshipTypes, OptionGroups with OptionValues, Groups, Tags, EventTypes, ActivityTypes, CustomGroups with CustomFields, Profiles

3. Config Export (Undeveloped) and exports into yml format. (Import is not handled)

4. Import/Export(CRM_Utils_Migrate) This script performs data migration like Contacts, Contributions etc but not settings. But you can use export script to export in json format and then import using using extension from #1 or #2.

5. You can also use CiviCRM UI import/functionality to import Contact and their related data.

Cheers

Pradeep