Support

Home Forums Event Espresso Premium Moving events to new site (SQL Databases)

Moving events to new site (SQL Databases)

Posted: June 13, 2018 at 10:01 am


KZNTR

June 13, 2018 at 10:01 am

We have created a new site and installed EE4. I have exported the MySQL database from the old site (also EE4), and imported it to the new site’s SQL database.

All the registrations are pulling through, without attendee information though. The events haven’t pulled through at all either. Surely this should be a simple transfer if all the event and reg data is stored on the database?

Please help!


Josh

  • Support Staff

June 13, 2018 at 10:05 am

Hi KZNTR,

Did you move all of the tables or only some of the tables? The reason I ask is because Attendees and Events are custom post types, so they’re recorded to the wp_posts table.


KZNTR

June 13, 2018 at 10:25 am

Ok that sounds like progress! I only moved the tables marked (esp)

Will moving wp_posts tables solve this?


Josh

  • Support Staff

June 13, 2018 at 11:48 am

That’s part of the solution. You’ll likely also want to copy over wp_postmeta to preserve meta data. Also the wp_term* tables should be copied over in order to preserve categories, tags, and any custom taxonomies that were used on the original site.


KZNTR

June 13, 2018 at 12:15 pm

Is there a way to copy these tables over without overwriting the tables on the dev site? We have a whole lot of pages and posts created.


Josh

  • Support Staff

June 13, 2018 at 12:38 pm

Overwriting tables is unavoidable, but you could do an export of the posts and pages on the dev site (in WP > Tools > Export), then copy over the database tables, then remove unwanted posts & pages, then import the posts and pages to the dev site (in WP > Tools > Import).


KZNTR

June 14, 2018 at 11:07 am

Thanks, that worked!

The support post ‘Moving events to new site (SQL Databases)’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

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: closed

Updated by  KZNTR 5 months, 4 weeks ago ago

Topic Tags

Tagged: 

Notifications

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