Support

Home Forums Event Espresso Premium Copy Event Espresso 4 events, registrations, messages & settings to new Website

Copy Event Espresso 4 events, registrations, messages & settings to new Website

Posted: June 23, 2022 at 1:56 pm


drumthwacketee

June 23, 2022 at 1:56 pm

Our client uses Event Espresso 4.10.30 on their current Website, and in the next few months we will activate our client’s new Website — which will also use Event Espresso 4.

We wish to copy the Event Espresso events, registrations, messages, and settings from the old Website to the new Website. From reading other forum messages about doing this, database tables will need to be copied over. Since this is a new Website, we can’t copy over ALL the old database tables to the new Website’s database.

What specific database tables does Event Espresso 4 use for events, registrations, messages, and settings?

Thank you.


Tony

  • Support Staff

June 24, 2022 at 9:10 am

Hi there,

As it stands we don’t have a solution for moving ‘just’ the EE4 data from one site to another. To explain a little Event Espresso uses a hybrid approach in which we use custom post types and custom tables.

All of the EE custom tables begin with {prefix}esp_, so if the prefix is wp_ (which I’ll use for all of my examples) the tables will begin with wp_esp_

However, as EE uses custom post types we also use wp_posts for Events, Registrations, Attendees (EE_Contacts) and others that I’m sure I’m missing from the list. We then use the ID for those rows within our custom tables as foreign keys which makes copying over ‘just’ the EE data from one site to another a much harder task as the ID’s must match again in the new site, so you can’t just import the rows into the new wp_posts table as the ID will auto-increment.

So for this type of setup to work, it would need some form of migration script to export the data from Site A, import it into Site B and then map all of the new foreign keys to the correct/new ID within the custom tables.


drumthwacketee

June 24, 2022 at 3:21 pm

Thank you for the info Tony, I’ll pass this on to our programmer.

You must be logged in to reply to this support post. Sign In or Register for an Account

Event Espresso