Support

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.

June 27, 2022 at 5:14 am

I realised there’s some additional info I didn’t add above with regards to options.

EE also stores options within wp_options and the prefix for those should be ee_ or the option name will usually contain _espresso_

I’ll happily provide any info I can if they have any additional questions.

June 27, 2022 at 7:36 am

You’re most welcome 🙂