Delete 4000 events

  • Resolved comepot

    (@comepot)


    5 years, 10 months ago

    Hi guys,
    How can I delete 4000 events from my DB? Or better compress/archive it?
    Where can I find Past Events in my DB? Also images? Is there a specific folder?
    Any one did it already?
    Thank you!
    El

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

  • Hi El,
    EM user here too.

    In the events list you can use the bulk actions to delete multiple events. 4000 at once is not possible, so you will need to do it several times.
    Deleting an event will also delete all booking and ticket info, if present.

    Locations will not be automatically deleted.

    It will not delete any images. Images are saved with their own ID’s by WordPress. You would have to delete those from the Media Library. That will delete all image sizes WP auto-created upon upload as well.

    Remember to empty the trash, or it will not be really deleted. ??

    As info:
    Doing a SQL query is not a good idea. EM saves data in several tables, linking them together: wp_posts, wp_postmeta, wp_em_events, wp_em_bookings, wp_em_tickets, wp_em_locations, etc. Chances are deleting them by query will still leave lots of “hidden” data. The bulk delete option will make sure all linked items are also deleted and/or updated.

    Thread Starter comepot

    (@comepot)

    Thank you Patrick, but it`s crazy to do it 40 times. I actually tried Bulk Delete Plugin, but it messed up a lot of things…

    Naturally, I meant the bulk delete option in the WordPress admin itself…

    Thread Starter comepot

    (@comepot)

    Is there any way to direct past events going to trash or being deleted automatically?

    No, not by default. That has a good reason ??

    Firstly, nothing in WP is automatically completely deleted, but it is sent to the trash, unless you have specified in your wp-config.php file to never use the trash option ever. (Disabling trash 100%).

    Deleting a post/page/event/location will always result in a 404-error, because the url is gone. Search engines, like Google, will punish you for having a lot of 404-errors by lowering you in the search results.

    The premium version of Yoast SEO can help you with that (or so their nagging free version keeps telling me…). Basically what is needed is a redirect from the deleted post/event to a still existing one.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Delete 4000 events’ is closed to new replies.