Completely Delete all Data from the DB

  • Resolved nikoza

    (@nikoza)


    11 years, 4 months ago

    Hello and thanks for the great plugin.

    I am using it in a site that gets a lot of traffic and I have both free and paid downloadable products. I want to keeping all the data for security and performance reasons out of the db.

    I noticed that all purchases are stored in the xx_posts table. How can I delete all the data stored in the db. I am not interested in any kind of reporting from the plugin as I do custom reports from my spreadsheets.

    I cannot seem to find any button that totally deletes everything.

    Is there something like that. If not what should I do?

    Regards,
    Nick

    https://www.ads-software.com/extend/plugins/easy-digital-downloads/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Pippin Williamson

    (@mordauk)

    Do you mean that you want to periodically delete the data, or that you need to delete all of the data just one time?

    Thread Starter nikoza

    (@nikoza)

    Hello Pippin,

    I would love to have a button in the options somwhere to delete everything from the DB and once every few days (manual click will be fine) but if it is not available any other custom solution I could use right now it will be just fine.

    Thank you

    Plugin Contributor Pippin Williamson

    (@mordauk)

    That will only be possible if you build it yourself, since it is pretty far outside of what a typical EDD user would need.

    If you’re able to build it yourself, I can tell you to the data to remove.

    Thread Starter nikoza

    (@nikoza)

    Hello Pippin,

    I really don’t believe that it is that far. I think many more than just be might be interested in keeping the db lighter. I assume that this will also increase the loading of the site.

    Let’s hope that I will be able to build it amd maybe as a plugin to release later. I think it will make a good one.

    Can you please tell me where in the db should I look?

    Regards,
    Nick

    Plugin Contributor Pippin Williamson

    (@mordauk)

    The increased size of the DB doesn’t impact site load time, not unless you have a plugin that is behaving improperly.

    Data you’d need to remove:

    From wp_posts: all items with the post_type = edd_payment
    From wp_postmeta: all items connected to the edd_payments items. Related by post_id.

    From wp_posts: all items with the edd_log post type
    From wp_postmeta: all items connected to the edd_log items, related by post_id.

    Plugin Contributor Pippin Williamson

    (@mordauk)

    FYI: when you delete payments, the file downloads associated with the purchases will fail.

    Thread Starter nikoza

    (@nikoza)

    Hello Pippin,

    Thank you for your help.
    I was away for a few days with now stable internet connections.

    I am about to finish the first version of the plugin that deletes purchases but I am confused of factors that I may have missed. Would you be interested in taking a look?

    Thank you again,
    Nick

    Plugin Contributor Pippin Williamson

    (@mordauk)

    Sure!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Completely Delete all Data from the DB’ is closed to new replies.