Identifying tables not used in posts

  • Resolved itheperson

    (@itheperson)


    2 years, 11 months ago

    Hi Tobias,

    We’ve been using Tablepress for many years (thank you). As a result we have over 400 tables, but the vast majority are no longer used within posts.

    Can you suggest a way to identify live tables so we can remove those which are redundant and taking up server resource?

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, there’s no direct way to achieve this. Your best chance would be to maybe search all your WordPress posts and pages (in the admin area) for a string like [table .
    This should then give you a list of posts/pages which have a table (as it should find all TablePress Shortcodes). You can then compile a list of table IDs that are still in use.

    You could maybe also do this with an SQL query in a tool like phpMyAdmin, which might be a bit faster, as it could show you the table IDs directly on the screen, without having to open each post/page.

    Regards,
    Tobias

    Thread Starter itheperson

    (@itheperson)

    Thanks for your quick reply Tobias, I presumed as much and will keep looking for a workable solution!

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sure, no problem! I hope it helps!

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Identifying tables not used in posts’ is closed to new replies.