Answers.Body: <p>Do you mean separating the Drupal and CiviCRM database on an active installation? If possible the easiest would be to re-install with separate databases.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-24T10:01:06.770Z
Answers.Text: Yes - it's a long running civicrm installation which has been upgraded to current, but i now want to separate them.. if i installed civicrm fresh with separate databases, what would the transfer process look like? - i assume i can't just copy the civicrm_ tables across?
Answers.UserDisplayName: user3016811
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-24T11:03:18.233Z
Answers.Text: This might help: https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-24T11:14:37.903Z
Answers.Text: hmm ok - from the sound of that i perhaps can do the equivalent of copy the civicrm_ tables (minus a few) - thanks, i'll try following that.
Answers.UserDisplayName: user3016811
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-29T17:53:18.617Z
Answers.Text: I ended up following these instructions https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+the+database+using+phpMyAdmin which has some manual elements, and it was successful.
  
  However, i also tried just duplicating the existing combined database (and removing the drupal tables, though that didn't seem critical) then referring to that from a drupal site with fresh standalone civi installed, and haven't noticed any issues.. is there anything i should be aware of doing that?
Answers.UserDisplayName: user3016811
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-24T09:23:05.673Z
Answers.LastActivityDate: 2017-10-24T09:23:05.673Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I'm using latest drupal 7 and civicrm.</p>
  
  <p>I have an existing drupal/civi install which uses the same database, and i'd like to switch to having separate databases - is that possible?</p>
  
  <p>The civi side is the important part fwiw.</p>
  
  <p>Thanks!</p>
  
Tags: <database>
Title: Switching from same-db to separate-db?
ThreadText: # Switching from same-db to separate-db?
  
  (Asked by: username_0 on 2017-10-24)
  
  I'm using latest drupal 7 and civicrm.
  
  I have an existing drupal/civi install which uses the same database, and i'd like to switch to having separate databases - is that possible?
  
  The civi side is the important part fwiw.
  
  Thanks!
  
  **Tags:** database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-10-24. Score: 1
  
  Do you mean separating the Drupal and CiviCRM database on an active installation? If possible the easiest would be to re-install with separate databases.
  
  > **Comments:**
  > **username_0**: Yes - it's a long running civicrm installation which has been upgraded to current, but i now want to separate them.. if i installed civicrm fresh with separate databases, what would the transfer process look like? - i assume i can't just copy the civicrm_ tables across?  
  > **username_1**: This might help: https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/  
  > **username_0**: hmm ok - from the sound of that i perhaps can do the equivalent of copy the civicrm_ tables (minus a few) - thanks, i'll try following that.  
  > **username_0**: I ended up following these instructions https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+the+database+using+phpMyAdmin which has some manual elements, and it was successful.  However, i also tried just duplicating the existing combined database (and removing the drupal tables, though that didn't seem critical) then referring to that from a drupal site with fresh standalone civi installed, and haven't noticed any issues.. is there anything i should be aware of doing that?  
  
  ---
  
  