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 »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • stand alone civicrm database
Pages: [1]

Author Topic: stand alone civicrm database  (Read 1480 times)

lhedrick

  • Guest
stand alone civicrm database
July 27, 2007, 06:43:10 am
I have a drupal/civicrm database which I would like to split apart.   Each day a mysqldump backup is created.  Is this just a matter of creating two databases, then hacking the mysql dump file.  Are all the civicrm tables prefixed with "civicrm_".  Is it safe to assume that after the restore of the new civicrm database the civicrm_settings.php file now just needs to point to the new database?

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: stand alone civicrm database
July 27, 2007, 07:52:57 am
Yes, all CiviCRM tables are prefixed with civicrm_, so you should be able to split the database using this rule. After splitting you'll have to adjust your civicrm and drupal settings files manually (remember to change both Drupal and CiviCRM MySQL DSNs in civicrm.settings.php), but apart from that it doesn't look like you should be doing any additional work. Well, actually, you might need to clear caches.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

speleo

  • Ask me questions
  • ****
  • Posts: 396
  • Karma: 28
  • CiviCRM version: 4.3.1
  • CMS version: J! 2.5,9
  • MySQL version: 5.1
  • PHP version: 5.3.24
Re: stand alone civicrm database
July 27, 2007, 09:27:43 am
I just went through the same exercise to seperate out the CiviCRM data from Joomla data. The easiest way to achieve this was simply to do it via a phpMyAdmin export, create the new db and then import. Didn't take long.

I did it so that I could look into moving from Joomla to Drupal as there is more support for Drupal out there and I really want to get a proper ACL. Had been really frustrated at the lack of progress with J!1.5 and then as soon as I did it 1.5RC1 hit the streets. Looks like ACL will come in 1.6, hopefully that wont take over a year. Shifting a lot of customisation and content to Drupal is non trivial...

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: stand alone civicrm database
July 27, 2007, 12:26:47 pm

If i had to guess, we will move all permissioning into CiviCRM in version 2.0 or version 2.1

Wes Morgan and the code for change team are making stellar progress with CiviCRM standalone. Its quite important for that project to have permissions independent of a CMS. We'll definitely be shooting to get this in CiviCRM as soon as possible (my next project after i'm done with the major schema changes!). This will be a big addition to our joomla integration obviously :)

lobo
 
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • stand alone civicrm database

This forum was archived on 2017-11-26.