Author Topic: Custom data from db backup (Read 788 times)

kmitz · February 14, 2010, 08:41:10 pm

Hey,

I had to do a reinstall of both Drupal and Civi. The original installation had a large number of custom fields that I would like to avoid entering manually. I have a db dump from the old installation (Civi 3.0.? -> 3.1.2).

After briefly looking at the dump file, it appears that the following tables had applicable data:

* civicrm_contact
* civicrm_import_job_<unique id>
* civicrm_value_primary_1 (primary was the grouping)
* civicrm_value_secondary_2 (secondary was the grouping)

Is it possible, using phpMySQLAdmin, to restore the original data, or at least the custom fields and the mappings?

kmitz

Civi 3.1.2/PHP 5.2/Linux/Drupal 6.15

Donald Lobo · February 14, 2010, 08:54:00 pm

if the old install is still around, u can use the "migrate" scripts (bin/migrate/{export,import}.php) to xfer the data

if not around, its a bit more challenging. u might want to look at:

http://svn.civicrm.org/civicrm/branches/v3.1/bin/migrate/export.php

to get an idea of the inter-dependencies. if u r familiar with php/sql, the tables are:

civicrm_custom_group
civicrm_custom_field
civicrm_option_group
civicrm_option_field

lobo

kmitz · February 15, 2010, 05:17:58 am

Thanks.

CiviCRM Community Forums (archive)

News:

Author Topic: Custom data from db backup (Read 788 times)

kmitz

Custom data from db backup

Donald Lobo

Re: Custom data from db backup

kmitz

Re: Custom data from db backup