Support

Home Forums Event Espresso Premium Migrating EE data to another WP website (both EE4) – data missing

Migrating EE data to another WP website (both EE4) – data missing

Posted: January 25, 2023 at 8:11 am


Omnishambles

January 25, 2023 at 8:11 am

We are trying to migrate events from old website to the new version we’re developing. Both sites run EE4 with extensions. The stepps I took so far:
– export all _esp_ tabled from the old website’s database
– copied all EE plugin files from old to new website
– imported the _esp_ tables to the new website’s database and adjusted the prefix
– activated the EE plugins on the new website

No data from the previous wesbite is available on the new one (events list in WP admin panel is empty), and I’ve noticed that after plugin activation, several new tables with _e_ in the name were created in the database.

Can you please provide instructions on how to best handle it – we have plenty of data on the old site and any form of manual migration is not an option.


Omnishambles

January 25, 2023 at 8:21 am

Seems that some of the data (Registrations, custom registration form, messages) were actually imported, but Events and Venues are missing on the new website


Tony

  • Support Staff

January 25, 2023 at 11:28 am

Hi there,

Many of the Event Espresso entities are custom post types, they are stored within wp_posts and then we use the ID from those within our custom tables as a foreign key to link all of the data together.

Ultimately that means you can’t export ‘just’ the EE data from Site A to Site B as you are doing above, you will need to copy all of the tables from Site A to Site B and then remove the unneeded data from the database.


Omnishambles

January 25, 2023 at 1:49 pm

Hi, thank for your reply. Is there any way we can export all the EE data from the old website and import it into the existing development site? Copying all the table is not an option at this point as other than EE information, the new website is now almost fully developed and we do not want to overwrite or lose any data already in the wp_posts table.


Tony

  • Support Staff

January 25, 2023 at 3:05 pm

Not currently no, if you export the data from Site A and import into Site B then a migration script is needed to update all of the foreign keys within the custom EE tables to match the new ID’s the entities will have.

We don’t have a migration script for this currently.

It ‘may’ be possible to do it the other way around…. export your NEW wp_post data, transfer the old database over in full and then import the new data but that depends on whatever you are using on the new site having an export option.

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

Event Espresso