Title: Easy Export / Import
Last modified: February 16, 2019

---

# Easy Export / Import

 *  Resolved [pasamike](https://wordpress.org/support/users/pasamike/)
 * (@pasamike)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/)
 * Is there an easy export / import option hiding some where? I have been working
   on a staging site that I need to take live. In the meantime events have been 
   added and modified. Thanks!

Viewing 10 replies - 1 through 10 (of 10 total)

 *  Thread Starter [pasamike](https://wordpress.org/support/users/pasamike/)
 * (@pasamike)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11214559)
 * 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.
 *  [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/)
 * (@duisterdenhaag)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11214887)
 * No easy import! Tables are linked together:
    wp_posts, wp_postmeta, wp_em_events,
   wp_em_bookings, wp_em_locations, etc.
 *  Thread Starter [pasamike](https://wordpress.org/support/users/pasamike/)
 * (@pasamike)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11215294)
 * 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
 *  [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/)
 * (@duisterdenhaag)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11215361)
 * 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.
    -  This reply was modified 7 years, 3 months ago by [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/).
 *  Thread Starter [pasamike](https://wordpress.org/support/users/pasamike/)
 * (@pasamike)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11215409)
 * 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?
 *  [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/)
 * (@duisterdenhaag)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11215413)
 * 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.
 *  Thread Starter [pasamike](https://wordpress.org/support/users/pasamike/)
 * (@pasamike)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11215517)
 * 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.
 *  [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/)
 * (@duisterdenhaag)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11215940)
 * o, I tried that.. DOesn’t work. It’ll give lots of errors.
 *  Thread Starter [pasamike](https://wordpress.org/support/users/pasamike/)
 * (@pasamike)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11223517)
 * Okay [@duisterdenhaag](https://wordpress.org/support/users/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.
 *  Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * (@angelo_nwl)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11279183)
 * another way maybe is looking for ical template at events-manager/templates/templates/
   ical.php

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Easy Export / Import’ is closed to new replies.

 * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=3550347)
 * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/events-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/)

## Tags

 * [events](https://wordpress.org/support/topic-tag/events/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 10 replies
 * 3 participants
 * Last reply from: [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/)
 * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/easy-export-import/#post-11279183)
 * Status: resolved