Answers.Body: <p>First, I think this is a comprehensive list, though Demerit obviously uses some integration tricks I don't, and others may as well.  </p>
  
  <p>Second, for concrete instructions on how to do steps 2-4 and 7, they're the same as the <a href="https://civicrm.stackexchange.com/a/26989/12">Drupal 8 database separation steps</a> that are documented here on Stack Exchange.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-26T05:39:55.523Z
Answers.LastActivityDate: 2019-07-26T05:39:55.523Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Maybe if you have some plugin that uses $wpdb to access civi tables. For example there are several workarounds to try to get the functionality of drupal views that isn't in wordpress, and if they're written as native wordpress plugins and not civicrm extensions maybe they would use $wpdb.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-02-25T19:28:12.967Z
Answers.LastActivityDate: 2019-02-25T19:28:12.967Z
Answers.UserDisplayName: Demerit
Body: <p>When we first installed CiviCRM - the installer was <a href="https://civicrm.stackexchange.com/questions/14629/cannot-separate-civicrm-database-tables-from-wordpress-tables-on-installation">super eager</a> to install using the existing WordPress database. We were just testing out CiviCRM at the time, so it was not a big deal - however we ended up sticking with CiviCRM and now we are migrating to a new server.  Before we migrate to the new server - we think now is a good time to separate the CiviCRM tables from the wordpress tables. Based on the stack mentioned above, I plan on doing the following:</p>
  
  <ol>
  <li>Enter site into "maintenance mode". i.e. temporarily close to public.</li>
  <li>Create a new civicrm database</li>
  <li>Export the civicrm tables from the original wordpress DB.</li>
  <li>Import the civicrm tables into the new civicrm database</li>
  <li>Edit wp-content/uploads/civicrm/civicrm.settings.php to point to the new civicrm-only DB.</li>
  <li>Test</li>
  <li>Drop the civicrm tables from the original wordpress database.</li>
  <li>Celebrate?</li>
  </ol>
  
  <p>Is there something else I should be aware of?</p>
  
Tags: <wordpress><mysql><sql>
Title: How do you separate wordpress and civicrm tables?
ThreadText: # How do you separate wordpress and civicrm tables?
  
  (Asked by: username_0 on 2019-02-25)
  
  When we first installed CiviCRM - the installer was [super eager](https://civicrm.stackexchange.com/questions/14629/cannot-separate-civicrm-database-tables-from-wordpress-tables-on-installation) to install using the existing WordPress database. We were just testing out CiviCRM at the time, so it was not a big deal - however we ended up sticking with CiviCRM and now we are migrating to a new server. Before we migrate to the new server - we think now is a good time to separate the CiviCRM tables from the wordpress tables. Based on the stack mentioned above, I plan on doing the following:
  
  1. Enter site into "maintenance mode". i.e. temporarily close to public.
  2. Create a new civicrm database
  3. Export the civicrm tables from the original wordpress DB.
  4. Import the civicrm tables into the new civicrm database
  5. Edit wp-content/uploads/civicrm/civicrm.settings.php to point to the new civicrm-only DB.
  6. Test
  7. Drop the civicrm tables from the original wordpress database.
  8. Celebrate?
  
  Is there something else I should be aware of?
  
  **Tags:** wordpress, mysql, sql
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-07-26. Score: 1
  
  First, I think this is a comprehensive list, though username_2 obviously uses some integration tricks I don't, and others may as well.
  
  Second, for concrete instructions on how to do steps 2-4 and 7, they're the same as the [Drupal 8 database separation steps](https://civicrm.stackexchange.com/a/26989/12) that are documented here on Stack Exchange.
  
  
  ---
  
  ### Answer by username_2 on 2019-02-25. Score: 1
  
  Maybe if you have some plugin that uses $wpdb to access civi tables. For example there are several workarounds to try to get the functionality of drupal views that isn't in wordpress, and if they're written as native wordpress plugins and not civicrm extensions maybe they would use $wpdb.
  
  
  ---
  
  