UPDATE: I tried to export/import the data to staging site, and the data is in a table with same name but the plug-in cannot find the event data.
No easy import! Tables are linked together:
wp_posts, wp_postmeta, wp_em_events, wp_em_bookings, wp_em_locations, etc.
Wow. Thats a real problem moving forward. I didn’t realize I couldn’t make use of my staging site for multiple changes anymore as using the posts table will override the newer content on pages. Yuck!
Thanks
You could first try using the native WordPress Importer/Exporter (Dashboard > Tools), but you cannot be selective to only events and locations, for example.
If you’re not afraid of SQL and do not care about the post ID, you can also export all wp_em_ tables and wp_posts and wp_postmeta as SQL format from your test server. On your new server: delete those (empty?) tables and import the old ones.
I did that myself last week when I had to suddenly move from provider. Worked great, but it takes the post ID and metas from the original server. It really clones it.
I tried export / import in PHPmyAdmin, cloned all _em_ tables listed and imported successfully. But when I open plugin it does not show any event data, like it has to be relinked to the tables? I made sure the tables are named the same in terms of prefix and still nothing. Is there just another step I don’t know about?
You need to clone wp_posts and wp_postmeta as well, because that is where WordPress actually looks for the info in the Dashboard. It there is nothing in those tables, WP will show nothing.
Can I “insert new only?” or do i have to manually merge the table and then import all? I dont mess with sql enough, and Im trying to avoid erasing the posts I do want to keep.
o, I tried that.. DOesn’t work. It’ll give lots of errors.
Okay @duisterdenhaag where is the face palm GIF??
I just realized this problem is showing on all events after Daylight Savings (March 10th). It does show correct on the site if i go to the event page, but do you know of a way to have the ical feed show the actual start time as opposed to an adjusted time for the events on ical feeds and such?
Thanks so much for all your help! Youre awesome.
another way maybe is looking for ical template at events-manager/templates/templates/ical.php
