Support

Home Forums Event Espresso Premium Transfer EE to a new Database/Site (same url, new site build)

Transfer EE to a new Database/Site (same url, new site build)

Posted: September 12, 2013 at 3:37 pm


ssarasvati

September 12, 2013 at 3:37 pm

Hi,

I just rebuilt my whole website with a fresh install of WP, new theme, new clean DB, etc., but I’d like to transfer all of my EE data from the old site/DB to the new one. What do I need to do this? It is important that we preserve all event/attendee data.

It seems that I should be able to just transfer the EE tables to the new DB, but I want to make sure I’m not missing anything essential.

Thanks!

WP 3.6
EE 3.1.34.1.P


Seth Shoultes

  • Support Staff

September 12, 2013 at 5:12 pm

I think transferring the database tables should be fine. You can also try the WP Migrate DB plugin. I have used that quite a few times when transferring customer databases to a local install of WP and Event Espresso. It finds all of the URLs that point to the old site and changes them to the new URL.


ssarasvati

September 12, 2013 at 5:26 pm

Because it’s a whole new site with new pages/posts/etc., we don’t want to migrate the whole DB – just EE. I’ll check that plugin and if it can somehow manage to do only specific tables that would be wonderful.

Thank you.


Dean

September 13, 2013 at 1:11 am

Hi,

It seems that it will onbly allow table selection in the premium version.

If you don’t wish to purchase it, then you could try using PHPMyAdmin like here http://support.wpengine.com/exporting-your-database/ or there will no doubt be many MySQL scripts out there that can point you to only exporting certain tables. With that sort of script you could use a WordPress plugin such as Adminer to run the script.

As always, back up the database first!


ssarasvati

September 13, 2013 at 6:45 pm

Ok, I’ll get to work on that. Once I have it all sorted out I’ll report back with exactly what I did just in case someone else finds them in this situation.

Thanks!


Dean

September 14, 2013 at 3:16 am

Thanks!


ssarasvati

September 16, 2013 at 11:04 am

Still no luck. Because we had the new registrations on the new site before all old data got transferred in I decided to insert the rows from the old tables into the new ones so that we could preserve ALL data. I used the method described here with this code:

INSERT IGNORE INTOlive_db.wp_events_answer`
SELECT *
FROM old_db.wp_events_answer`

Of course I did this for each *_events_* table individually. However, I do not see any of the old data…

Any ideas?

Thanks!


ssarasvati

September 16, 2013 at 11:16 am

*EDIT*

We can see all of the old events, but there is no attendee information…


Dean

September 17, 2013 at 4:25 am

Can I ask what version of Event Espresso was the old site running?


ssarasvati

September 17, 2013 at 1:25 pm

Originally EE 3.1.34.1.P, now 3.1.35.P


Josh

  • Support Staff

September 17, 2013 at 2:38 pm

Because it’s a whole new site with new pages/posts/etc., we don’t want to migrate the whole DB – just EE. I’ll check that plugin and if it can somehow manage to do only specific tables that would be wonderful.

The Pro version of WP Migrate DB (Pro) lets you select only the tables you want to migrate:

https://deliciousbrains.com/wp-migrate-db-pro/

The support post ‘Transfer EE to a new Database/Site (same url, new site build)’ 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  Josh 6 years, 2 months ago ago

Topic Tags

Notifications

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