Answers.Body: <p>That's really two operations: splitting the combined db to separate WP and Civi ones, and migrating.  For the migration part <a href="https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/" rel="noreferrer">see the manual</a>.</p>
  
  <p>To split the db, you could make a duplicate of the original as the Civi db (dump and load), then in the Civi one delete all the non-civi tables and in the original/WP one, delete all the civi tables.  In your <code>civicrm.settings.php</code> file find the setting for <code>CIVICRM_DSN</code> and change it to use the new database name.</p>
  
  <p>Make sure you keep a backup of your original combined db just in case!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-30T16:41:07.110Z
Answers.Text: So doing that wouldn't break the integration with the WordPress backend?
Answers.UserDisplayName: Jamie Fraser
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-30T08:14:28.993Z
Answers.LastActivityDate: 2019-04-30T08:14:28.993Z
Answers.UserDisplayName: Aidan
Body: <p>On my initial setup, I had installed CiviCRM onto the same database as the Wordpress installation.
  Now I want to split this as I am migrating the website and would rather backup and have a copy of the CiviCRM installation on its own.
  Does anyone have any advice on how this could be accomplished?
  Can I just backup the existing DB and restore to a new instance and it would all just work?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-04-29T19:16:15.847Z
Comments.Text: feel i have seen similar questions before though it may have been in chat
Comments.UserDisplayName: petednz - fuzion
Tags: <wordpress><upgrade><database><installation>
Title: Split Data from Wordpress Database
ThreadText: # Split Data from Wordpress Database
  
  (Asked by: username_0 on 2019-04-29)
  
  On my initial setup, I had installed CiviCRM onto the same database as the Wordpress installation.
  Now I want to split this as I am migrating the website and would rather backup and have a copy of the CiviCRM installation on its own.
  Does anyone have any advice on how this could be accomplished?
  Can I just backup the existing DB and restore to a new instance and it would all just work?
  
  **Tags:** wordpress, upgrade, database, installation
  
  > **Comments:**
  > **username_1**: feel i have seen similar questions before though it may have been in chat  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-04-30. Score: 6
  
  That's really two operations: splitting the combined db to separate WP and Civi ones, and migrating. For the migration part [see the manual](https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/).
  
  To split the db, you could make a duplicate of the original as the Civi db (dump and load), then in the Civi one delete all the non-civi tables and in the original/WP one, delete all the civi tables. In your `civicrm.settings.php` file find the setting for `CIVICRM_DSN` and change it to use the new database name.
  
  Make sure you keep a backup of your original combined db just in case!
  
  > **Comments:**
  > **username_0**: So doing that wouldn't break the integration with the WordPress backend?  
  
  ---
  
  