CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • same or different database
Pages: [1]

Author Topic: same or different database  (Read 661 times)

mudnik

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 0
  • CiviCRM version: 4.5.3
  • CMS version: drupal
  • MySQL version: 5.5.34-cll
  • PHP version: 5.4.23
same or different database
November 22, 2013, 07:35:59 am
Is it better to install drupal and civicrm in the same database or different ones?

I understand there will be some views integration problems if I install them separately.

If I already install them separately, should I move them into the same database?

What's the best practices?

kreynen

  • I post occasionally
  • **
  • Posts: 105
  • Karma: 8
Re: same or different database
November 22, 2013, 08:38:36 am
Quote
I understand there will be some views integration problems if I install them separately.

If by problems you mean an extra step, then yes... using separate databases requires you to go to CiviCRM > Administer > System Settings > CMS Integration and copy the array generated to your Drupal settings.php file. 

IMHO it is easier to understand where data is stored and deal with update and rolling back changes when the databases are separate, but in some hosting environments (like Pantheon) you are forced to use a single database for both the Drupal and CiviCRM tables.

mudnik

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 0
  • CiviCRM version: 4.5.3
  • CMS version: drupal
  • MySQL version: 5.5.34-cll
  • PHP version: 5.4.23
Re: same or different database
November 22, 2013, 05:27:01 pm
Thanks Kreynen.

Previously, I had some trouble getting the integration to work but it works now.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: same or different database
November 23, 2013, 09:17:41 am
Best practice is definitely two databases, and as noted, there should be no problems with Views integration.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • same or different database

This forum was archived on 2017-11-26.