Cleaning wp_postmeta database

  • Resolved wpturk

    (@wpturk)


    6 years, 3 months ago

    Hi,

    What is the best way to clean the wp_postmeta database from “tiny_compress_images” etc. entries. It’s ok, if the images will be shown as not optimised in the end.

    Which rows can be deleted?

    • This topic was modified 6 years, 3 months ago by wpturk.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TinyPNG

    (@tinypng)

    Hi, each image when optimized will get some additional info in the wp_postmeta table, where the post_id refers to the image. To get a list of all records that contain optimization information you could probably enter a SQL querie like this:

    SELECT * FROM wp_postmeta WHERE meta_key = "tiny_compress_images";

    Thread Starter wpturk

    (@wpturk)

    Is it safe to:

    DELETE FROM wp_postmeta WHERE meta_key ="tiny_compress_images";

    Are there any other entries from your plugin in postmeta table?

    Thread Starter wpturk

    (@wpturk)

    Any news on this?

    I want to keep on using your plugin but is it ok to delete these entries below? (I don’t need the compress info)

    DELETE FROM wp_postmeta WHERE meta_key =”tiny_compress_images”;

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cleaning wp_postmeta database’ is closed to new replies.