Support » Plugin: Link Library » Need SQL to clear links pls

  • Resolved gerritv

    (@308gv)


    Hi
    My database is a mess from various attempts to build a site and trying various plugins. Can you give me a SQL statement to delete Link Library items out of Posts and Post_meta tables? I never seem to get Joins right 🙁 Deleting the library from Global page doesn’t work for some reason.

    Then I can start over.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Yannick Lefebvre

    (@jackdewey)

    The best tool I have found to easily delete links created by Link Library is to use the plugin called Bulk Delete (https://wordpress.org/plugins/bulk-delete/). Once installed, click on Bulk WP menu, then scroll down and find the By Post Type section and choose to delete Links. This will take care of deleting all posts and associated post meta.

    If you have already partially delete part of the data and Bulk Delete won’t work for you, I would say to delete all posts where the post_type field is link_library_links and all post_meta fields where the meta key name starts with link_

    By the way, there is no button to delete the links from the library in Global Options. The only delete thing is to delete old links from version 5.9, not from current 6.x version.

    Let me know if this helps you and please consider donating to support this plugin’s development.

    Thank you, hadn’t thought of looking for a plugin, that sounds very useful. In meantime I did figure out the Join SQL and managed to tidy things up from past experiments. I will try to donate within the next month.

    Thank you for your help.

    Plugin Author Yannick Lefebvre

    (@jackdewey)

    Glad to hear you figured out the SQL. Bulk Delete is definitely a great cleanup tool. Thanks in advance for the upcoming support. Cheers.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.