wordpress-mysql-databaseWordPress stores all the data in mysql database.We all know about it. But have you ever tried to understand the usage of different tables of that database.

In this article, we’ll discuss the basic structure of WordPress Database.

You’ll need this knowledge in future when editing database manually or in troubleshooting.

WordPress database comprises of following tables:

wp_posts
wp_postmeta
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_users
wp_usermeta
wp_comments
wp_commentmeta
wp_options
wp_links

This section is the overview of all the tables created during the WordPress standard installation. It is followed by specific information of what is in each table.

WordPress 3.8 Tables (11)
Table Name Description Relevant Area(s) of WordPress User Interface
wp_commentmeta Each comment features information called the meta data and it is stored in the wp_commentmeta.
  • Administration > Comments > Comments
wp_comments The comments within WordPress are stored in the wp_comments table.
  • Administration > Comments > Comments
wp_links The wp_links holds information related to the links entered into the Links feature of WordPress. (This feature has been deprecated, but can be re-enabled with the Links Manager plugin.)
  • Administration > Links > Add New
  • Administration > Links > Links
wp_options The Options set under the Administration > Settings panel are stored in the wp_options table. See Option Reference for option_name and default values.
  • Administration > Settings > General
  • Administration > Settings > Writing
  • Administration > Settings > Reading
  • Administration > Settings > Discussion
  • Administration > Settings > Privacy
  • Administration > Settings > Permalinks
  • Administration > Appearance > Widgets
wp_postmeta Each post features information called the meta data and it is stored in the wp_postmeta. Some plugins may add their own information to this table.
  • Administration > Posts > Add New
  • Administration > Pages > Add New
wp_posts The core of the WordPress data is the posts. It is stored in the wp_posts table. Also Pages and navigation menu items are stored in this table.
  • Administration > Posts > Add New
  • Administration > Posts > Posts
  • Administration > Pages > Add New
  • Administration > Pages > Pages
  • Administration > Media > Add New
  • Administration > Media > Library
  • Administration > Appearance > Menus
wp_terms The categories for both posts and links and the tags for posts are found within the wp_terms table.
  • Administration > Posts > Post Tags
  • Administration > Posts > Categories
  • Administration > Links > Link Categories
  • Administration > Posts > Add New
  • Administration > Posts > Posts
  • Administration > Pages > Add New
  • Administration > Page > Pages
wp_term_relationships Posts are associated with categories and tags from the wp_terms table and this association is maintained in the wp_term_relationships table. The association of links to their respective categories are also kept in this table.
wp_term_taxonomy This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
wp_usermeta Each user features information called the meta data and it is stored in wp_usermeta.
  • Administration > Users
wp_users The list of users is maintained in table wp_users.
  • Administration > Users
READ  How to Speed Up WordPress With Leverage Browser Caching?
Understanding the structure of the WordPress Database
5 (100%) 1 vote
https://zwordpress.com/wp-content/uploads/2016/10/wordpress-mysql-database.jpghttps://zwordpress.com/wp-content/uploads/2016/10/wordpress-mysql-database-150x150.jpgWordPressWordPress TutorialsWordPress DatabaseWordPress stores all the data in mysql database.We all know about it. But have you ever tried to understand the usage of different tables of that database. In this article, we'll discuss the basic structure of WordPress Database. You'll need this knowledge in future when editing database manually or in troubleshooting. Wordpress...Wordpress Plugins, Themes, Tutorials, Snippets, How-to