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 4 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[gravityform id=80 title=false description=false ajax=false]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_80' ><form method='post' enctype='multipart/form-data' id='gform_80' action='/topic/we-are-trying-to-migrate-a-site-with-event-espresso-data/'> <div class='gform_body'><ul id='gform_fields_80' class='gform_fields top_label form_sublabel_below description_below'><li id='field_80_1' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_1' >First name<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_1' id='input_80_1' type='text' value='' class='medium' aria-required="true" aria-invalid="false" /></div></li><li id='field_80_2' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_2' >Email address<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_80_2' type='email' value='' class='medium' aria-required="true" aria-invalid="false" /> </div></li><li id='field_80_3' class='gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' >GDPR Agreement<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_checkbox'><ul class='gfield_checkbox' id='input_80_3'><li class='gchoice_80_3_1'> <input name='input_3.1' type='checkbox' value='I consent to have this website store my submitted information so they can respond to my inquiry.' id='choice_80_3_1' /> <label for='choice_80_3_1' id='label_80_3_1'>I consent to have this website store my submitted information so they can respond to my inquiry.</label> </li></ul></div></li><li id='field_80_4' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_80_4' >Comments</label><div class='ginput_container'><input name='input_4' id='input_80_4' type='text' value='' autocomplete='off'/></div><div class='gfield_description' id='gfield_description_80_4'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_80' class='gform_button button' value='Download Now' onclick='if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_80"]){return false;} if( !jQuery("#gform_80")[0].checkValidity || jQuery("#gform_80")[0].checkValidity()){window["gf_submitting_80"]=true;} jQuery("#gform_80").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_80' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='80' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_80' value='WyJbXSIsIjBiNjdjZjkyMDUzOWUxOWY5Y2NiZjIwMzM4YjA1Mjk4Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_80' id='gform_target_page_number_80' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_80' id='gform_source_page_number_80' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 80) {} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [80, 1]) } ); </script>
[i]
[i]