Support

Home Forums Event Espresso Premium We are trying to migrate a site with Event Espresso Data

We are trying to migrate a site with Event Espresso Data

Posted: May 28, 2020 at 2:09 am


Andy Buck

May 28, 2020 at 2:09 am

On our development version, we deleted all event espresso data, and then pulled the EE tables from the live site using migrate DB pro. This seemed to work well, except for contact details for registrations which has not pulled over and are missing.


Andy Buck

May 28, 2020 at 2:12 am

We did try to migrate the site using this method:

1. Run the WordPress core export tool on the staging site, then set that backup aside for now
2. Put the live site into Event Espresso’s maintenance mode, then migrate the live site’s database to the staging site
3. Then delete all standard WP posts/pages on the staging site
4. Then run the WordPress import tool to import the WP posts/pages (restoring the staging site’s posts & pages)
5. If there are other custom things like theme options & widgets those would need to be re-imported too. Verify the staging site looks & functions exactly as you intend it too
6. Take one last backup of the live site (just in case step 7 does not go as planned)
7. Migrate the staging site to live site using a tool like WP Migrate DB
8. Deactivate Maintenance mode
9. Verify the live site looks & functions exactly as you intend it too

But as a result all the ACF data and images were broken/menus broken etc.


Tony

  • Support Staff

May 28, 2020 at 9:12 am

Hi Andy,

In short, because Event Espresso use custom post types for various data (Events, Contacts, Venues, People) there isn’t a way to migrate only EE data from one site to another without pulling the entire database.

The problem with exporting and import the posts/events/anything is the ID’s will change in the DB. ANy related data will then not… relate, as the foreign keys no longer match up.

To export EE data from site A to site B we’ll need some form of migration script that maps all related data ID’s to their new IDs. This is not something we currently have and it’s not something we can just throw together in a snippet due to the sheer number of relationships within EE.

The solution Josh posted above is about the closest you’ll get currently.

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

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: publish

Updated by  Tony 1 month, 1 week ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!