Answers.Body: <p>Ashok welcome to CiviCRM stackexchange</p>
  
  <p>If you new CiviCRM database has not gone live than i would </p>
  
  <ol>
  <li>Create a test instance of CRM 5.4.0</li>
  <li>Upgrade CiviCRM to 5.15.2</li>
  <li>Dump the Civi database after upgrade.</li>
  <li>Drop the Civi database or all civi table from CiviCRM database i.e linked to your new Wordpress.</li>
  <li>Import the CiviCRM database that was dumped at #3</li>
  <li>Open CiviCRM from UI.</li>
  <li>Clear CiviCRM cache by navigating to Administer >> System Settings >> Cleanup Caches and Update Paths.</li>
  <li>Rebuild trigger by running <a href="http://domain.orn/wp-admin/admin.php?page=CiviCRM&amp;q=civicrm/menu/rebuild&amp;reset=1&amp;triggerRebuild=1" rel="nofollow noreferrer">http://domain.orn/wp-admin/admin.php?page=CiviCRM&amp;q=civicrm/menu/rebuild&amp;reset=1&amp;triggerRebuild=1</a></li>
  </ol>
  
  <p>If you don't like above approach then you can use extension that migrates settings from one site to another</p>
  
  <ol>
  <li><p><a href="https://github.com/CiviCooP/org.civicoop.configitems" rel="nofollow noreferrer">Config Items</a> - 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!)</p></li>
  <li><p><a href="https://github.com/catorghans/net.trinfinity.orgis.mi.dataquality" rel="nofollow noreferrer">MI Data quality Tools</a> - This tool supports adding and updating using json method
  ContactTypes, MembershipTypes, RelationshipTypes, OptionGroups with OptionValues, Groups, Tags, EventTypes, ActivityTypes, CustomGroups with CustomFields, Profiles</p></li>
  <li><p><a href="https://github.com/xurizaemon/civicrm-configexport" rel="nofollow noreferrer">Config Export</a> (Undeveloped) and exports into yml format. (Import is not handled)</p></li>
  <li><p>Import/Export(<a href="https://books.google.co.uk/books?id=KKjWDQAAQBAJ&amp;pg=PA242&amp;lpg=PA242&amp;dq=CRM_Utils_Migrate%20civicrm&amp;source=bl&amp;ots=FcUPvPCYa2&amp;sig=ACfU3U0qOmZgTvScl9wXfUHbLepD0mMf4w&amp;hl=en&amp;sa=X&amp;ved=2ahUKEwjF09L0tebjAhUkWhUIHZY6AQYQ6AEwCXoECAkQAQ#v=onepage&amp;q=CRM_Utils_Migrate%20civicrm&amp;f=false" rel="nofollow noreferrer">CRM_Utils_Migrate</a>) 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.</p></li>
  <li>You can also use CiviCRM UI import/functionality to import Contact and their related data.</li>
  </ol>
  
  <p>Cheers</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-03T09:49:27.677Z
Answers.LastActivityDate: 2019-08-03T09:49:27.677Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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.</p>
  
  <p>I had a separate database for CiviCRM. When I installed &amp; activated new version CRM plugin, it created tables in existing wordpress database.</p>
  
  <p>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. </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-04T05:36:40.713Z
Comments.Text: what do you want in the end, a single db or a separate one for WP?
Comments.UserDisplayName: petednz - fuzion
Tags: <wordpress><import><export>
Title: Import/export database from old CRM version(5.4.0) to New CRM version(5.15.2) in wordrpess
ThreadText: # Import/export database from old CRM version(5.4.0) to New CRM version(5.15.2) in wordrpess
  
  (Asked by: username_0 on 2019-08-03)
  
  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.
  
  **Tags:** wordpress, import, export
  
  > **Comments:**
  > **username_1**: what do you want in the end, a single db or a separate one for WP?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-08-03. Score: 2
  
  username_0 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](https://github.com/CiviCooP/org.civicoop.configitems) - 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](https://github.com/catorghans/net.trinfinity.orgis.mi.dataquality) - 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](https://github.com/xurizaemon/civicrm-configexport) (Undeveloped) and exports into yml format. (Import is not handled)
  4. Import/Export([CRM\_Utils\_Migrate](https://books.google.co.uk/books?id=KKjWDQAAQBAJ&pg=PA242&lpg=PA242&dq=CRM_Utils_Migrate%20civicrm&source=bl&ots=FcUPvPCYa2&sig=ACfU3U0qOmZgTvScl9wXfUHbLepD0mMf4w&hl=en&sa=X&ved=2ahUKEwjF09L0tebjAhUkWhUIHZY6AQYQ6AEwCXoECAkQAQ#v=onepage&q=CRM_Utils_Migrate%20civicrm&f=false)) 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
  
  username_2
  
  
  ---
  
  