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 »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Separate database
Pages: [1]

Author Topic: Separate database  (Read 993 times)

juggleboy

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
Separate database
July 27, 2010, 10:16:43 am
Hello

I want to create a separate database for CiviCRM (rather than using the Joomla one).

How would I do this?

Thanks for any help.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Separate database
July 27, 2010, 10:46:06 am
1. Install CiviCRM on joomla.
2. Create new civicrm database and structure sql/civicrm.mysql
3. Then import essential data sql/civicrm_data.mysql
4. Modify below files to change civicrm db to new db.
administrator/components/com_civicrm/civicrm.settings.php
components/com_civicrm/civicrm.settings.php

5. Logout / login to joomla

Hth

Kurund
Found this reply helpful? Support CiviCRM

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Separate database
July 27, 2010, 06:04:36 pm
instead of step 2/3, you probably can just move the civicrm_ tables to the new db (if it's on the same server) or dump them with the structure+data. you may need to set the settings field in the civicrm_domain table to null to force it to reset. the important thing is to initially install in Joomla and then move it, so that the component is properly registered into Joomla as an extension.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Separate database

This forum was archived on 2017-11-26.