Restore events from database

[Lynne DAutrechy]

My client somehow lost events entered during a two-day period in August. I was able to find the events in a backup copy of the database. Can I just add those event records to the current database? She is also using WooCommerce Tickets to sell tickets to scheduled events.

[Nico]

Howdy @buzzquake,

Welcome to our support forums and thanks for reaching out to us. Hopefully inserting those Events Back in the database should do the trick, you’ll need to add the ‘wp_posts’ table entries and the corresponding entries from ‘wp_postmeta’ table as well. Make sure that the post IDs from the lost events you are trying to import doesn’t exist in the database already. In that case change the SQL to insert them manually.

The same thing goes for Venues, Organizers and Tickets – I guess your friend won’t remember if she created any of those during the two-day period, so maybe comparing the ‘wp_postmeta’ table version is a good idea. Take a look at this article giving some options to do so: http://stackoverflow.com/questions/225772/compare-two-mysql-databases.

Hope that helps, and please let me know if you can manage to import the lost data,
Best,
Nico

[Lynne DAutrechy]

This reply is private.

[Nico]

Hi Lynne,

Thanks for following up on this! Unfortunately I cannot do this for you – it would be out the support scope we can provide here.

If there are not many events I would recommend to create them manually. But another possibility might be to restore the back-up db intro a local site and export events, venues and organizers using the WordPress Importer, and importing them into the ‘current site’, using the same tool. If you do note that you should import venues and organizers first, then Events.

Please let me know if you can manage to restore the events this way,
Best,
Nico

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts