|
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
|
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
|
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
|
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!
|
