Clean up database after plugin uninstall

  • Resolved Mikey_

    (@mikeyuen)


    2 years, 2 months ago

    Apple News never accepted my application, and so I sadly uninstalled the Publish to Apple News plugin a while ago.

    I found that apple_news_api_* and apple_news_article* entries still exist in the database. How do I clean up all the data that the plugin left behind?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Mikey_

    (@mikeyuen)

    2 years, 2 months ago

    I played around with phpadmin and discovered the following queries:

    SELECT * FROM mysqldatabase.wp_postmeta WHERE (CONVERT(meta_key USING utf8) LIKE ‘apple_news_%’)

    This allowed me to delete all the metadata for every post.

    SELECT * FROM mysqldatabase.wp_options WHERE (CONVERT(option_name USING utf8) LIKE ‘apple_news_%’)

    This allowed me to remove the plugin options, but I decided to leave them alone in case I install it again.

    Be sure you make a backup of the database before modifying it.

    Plugin Author Kevin Fodness

    (@kevinfodness)

    2 years, 1 month ago

    The plugin intentionally doesn’t delete metadata associated with posts on uninstall for a few reasons:

    1) This metadata is not easily reproducible once deleted, especially the metadata that links a WordPress post to an item in Apple News. Apple News does not maintain an association with WordPress post IDs, so it’s not possible to recreate these association if deleted.

    2) On larger sites, deleting that much postmeta in bulk could easily cause timeouts.

    The approach you took to delete via the DB is the correct one.

    Thread Starter Mikey_

    (@mikeyuen)

    2 years, 1 month ago

    Thank you for the clarification, @kevinfodness. Appreciate the follow-up

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Clean up database after plugin uninstall’ is closed to new replies.