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) »
  • Best Method for Db minus contacts
Pages: [1]

Author Topic: Best Method for Db minus contacts  (Read 688 times)

emilyf

  • Ask me questions
  • ****
  • Posts: 696
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Best Method for Db minus contacts
May 17, 2010, 07:48:16 am
My org is running Civi with a bunch of different membership types, contrib types, event types, payment processors, custom data, profiles, groups, tags, you name it. They want to be able to take all of this and essentially give this custom install to other affiliates to use. But the catch is they don't want any of the contacts or contact-related info in it. I'm concerned this might get complicated to do a db dump that includes all these customization yet no contact (or membership, activity, contrib, etc) information whatsoever. Is all of this type of info stored in only a  few tables? Would I just exclude data dumps from specific tables? I'm concerned about FKs and anything else like this that could eventually lead to database corruption because I removed certain data that I shouldn't have.

thanks much.

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: Best Method for Db minus contacts
May 17, 2010, 08:02:26 am

if you are using 3.1 check the scripts

bin/migrate/{import,export}.php

basically that script allows you to move custom field/group, profile field/group and a few option groups.

You might want to consider extending that script (and sharing it back with the community), since that is a better way of transferring data rather than a DB dump

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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Best Method for Db minus contacts

This forum was archived on 2017-11-26.