Author Topic: how can you save custom fields for abother database? (Read 1118 times)

webguy2 · August 20, 2009, 05:49:26 am

I have to start over with a new database but have lots of custom fields I need to preserve.

How can I do that? Can I export them to sql file? Can I export certain tables that would carry the custom field info?

Thanks!

Deepak Srivastava · August 21, 2009, 12:11:18 am

If its just the custom groups and fields (but not the values stored for entity like contact, contribution .etc), you 'll need -
1. data dump of civicrm_custom_group and civicrm_custom_field tables.
2. structure dump for all the tables which are result of this query - "SELECT `table_name`FROM `civicrm_custom_group`;"

In #1 data dump make sure its the civicrm_custom_group table info that appears before civicrm_field, otherwise you 'll receive foreign key errors (unless you disable them during import).

Donald Lobo · August 21, 2009, 05:05:55 am

there are also two scripts packaged in the distribution:

bin/migrate/export.php
bin/migrate/import.php

which can help you move custom group/fields, profile groups/fields across databases.

lobo

webguy2 · August 21, 2009, 07:03:35 am

lobo - I've seen the files and read the PHP scripts. How does that help in moving custom fields and groups across dbs?

Donald Lobo · August 21, 2009, 08:31:13 am

export.php exports the custom group/fields etc as an xml file.

take that xml file and place it on the new server

import.php imports that xml file and loads it on the new server

lobo

webguy2 · August 21, 2009, 08:41:16 am

wow, I missed that boat completely.

Many thanks!!

CiviCRM Community Forums (archive)

News:

Author Topic: how can you save custom fields for abother database? (Read 1118 times)

webguy2

how can you save custom fields for abother database?

Deepak Srivastava

Re: how can you save custom fields for abother database?

Donald Lobo

Re: how can you save custom fields for abother database?

webguy2

Re: how can you save custom fields for abother database?

Donald Lobo

Re: how can you save custom fields for abother database?

webguy2

Re: how can you save custom fields for abother database?