Cleaning terms in database

  • Resolved kuyuch

    (@kuyuch)


    4 years, 8 months ago

    Hi all,

    To keep a long story short, i’m trying to get rid of all the taxonomy terms and values on our server, so everything is like fresh. We’ve had alot of issues with the attributes the past weeks and to me it seems like alot of unnecessary stuff is in our database within the
    – wp_termmeta containing 14477 rows
    – wp_terms containing mostly the categories. Seems fine but on some sites i see thats it is supposed to contain the actual term names.
    – wp_term_relationships containing 11161 rows
    – wp_term_taxonomy containing 219 rows some having empty counts

    Would it be safe for me to fully empty some of these tables? Any tips would be appreciated!

    Kind regards

Viewing 1 replies (of 1 total)
  • Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Hey there!

    We don’t recommend deleting or emptying tables in almost any cases.

    If you want to delete attributes or taxonomies, we would recommend doing that from the dashboard.

    The terms tables hold a lot more than just attributes:

    The table wp_terms stores Categories and tags for posts, pages, and links.

    One of the columns in this table is ‘slug ‘. A slug is a term that reflects a tag of a particular post. In WordPress, you can use tags to connect posts, pages, and links between each other.

    wp_term_relationship is the conjunction and connects these tags to posts, pages, and links. It’s like a map between the terms objects and the terms.

    wp_term_taxonomy extends the table wp_terms with more data. It’s like metadata for the table wp_terms with the difference that plugins cannot add custom data here. This table also contains relation between menus and menu items.

    Hopefully that helps! Have a great one!

Viewing 1 replies (of 1 total)
  • The topic ‘Cleaning terms in database’ is closed to new replies.