Author Topic: Copying civicrm_event from one instance to another (Read 798 times)

sonicthoughts · October 06, 2010, 10:22:45 am

I've been trying to upgrade a partially upgraded 3.01 instance and given up. tried the DharmaTech tools, Tried the http://wiki.civicrm.org/confluence/display/CRMDOC32/Ensuring+Schema+Integrity+on+Upgrades and at this point believe the best course is to do a clean install.

I can migrate everything i need, but not sure about events. Is it absolutely necessary to go through the API or can I just export from one database to another (ie copy civicrm_event table? When events are created is the civicrm_event table the only table updated? I realize addresses wont migrate, but is there other logic or table updates when adding an event that i should worry about?

I know there is a contributed script, but this is much simpler unless I'm missing something ...

S.

Hershel · October 08, 2010, 02:49:23 am

Quote from: sonicthoughts on October 06, 2010, 10:22:45 am

I can migrate everything i need, but not sure about events. Is it absolutely necessary to go through the API or can I just export from one database to another (ie copy civicrm_event table? When events are created is the civicrm_event table the only table updated? I realize addresses wont migrate, but is there other logic or table updates when adding an event that i should worry about?

It depends on your installation. With custom data then for sure there are other records in other tables, not to mention participation records. Overall, I certainly wouldn't recommend just copying a table like that. In particular if your install is new then certain foreign keys referenced will probably be wrong.

The API is certainly the way to go.

CiviCRM Community Forums (archive)

News:

Author Topic: Copying civicrm_event from one instance to another (Read 798 times)

sonicthoughts

Copying civicrm_event from one instance to another

Hershel

Re: Copying civicrm_event from one instance to another