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