Home / Wordpress / Beginner’s Guide to WordPress Database Management

Beginner’s Guide to WordPress Database Management

WordPress installation has 11 default tables in the database. Each database table contains data for different sections, features, and functionality of WordPress.

WordPress installation creates the following tables:

  1. wp_commentmeta :

wp_commentmeta table contains meta information about comments posted on a WordPress website. Table has four fields’ meta_id, comment_id, meta_key, and meta_value. Each meta_id is related with a comment_id. One example of comment Meta information stored is the status of comment.

  1. wp_comments :

Table contains your WordPress comments. It contains comment author name, url, email, comment, etc.

  1. wp_links :

To manage blogrolls create by earlier versions of .

  1. wp_options :

This table contains most of your WordPress site wide settings such as: site url, admin email, default category, posts per page, time format, and much much more. The options table is also used by numerous WordPress plugins to store plugin settings.

  1. wp_postmeta :

This table contains Meta information about your WordPress posts, pages, and custom post types. Example of post meta information would be which template to use to display a page, custom, etc. Some plugins would also use this table to store plugin data such as WordPress SEO information.

  1. wp_posts :

The name says posts but actually this table contains all post types or should we say content types. This table contains all your posts, pages, revisions, and custom post types.

  1. wp_terms :

WordPress has a powerful taxonomy system that allows you to organize your content. Individual taxonomy items are called terms and they are stored in this table. Example, your WordPress categories and tags are taxonomies, and each category and tag inside them is a term.

  1. wp_term_relationships :

wp_term_relationships wordpress database table manages relationship of WordPress post types with terms in wp_terms table.

  1. wp_term_taxonomy :

This table defines taxonomies for terms defined in wp_terms table. In short this table has the data that helps WordPress differentiate between which term is a category, which is a tag, etc.

  1. wp_usermeta:

It contains Meta information about Users on your website.

  1. wp_users:

It Contains User information like username, password etc.

About Chetan Kalbande

• Working knowledge in Magento, Wordpress, Joomla, PHP, HTML5, CSS3, Bootstrap front-end framework and Foundation front-end framework. Experience of PSD to HTML and HTML to Wordpress. Having knowledge on theme development of Wordpress, directory structure and responsive UI of Magento. E-Commerce development using Magento, Opencart, Woo-Commerce . Clean , attractive and responsive website development using Wordpress and Drupal. Estimation, design and development of various modules. Work on Search Engine Optimization to improve the search engine rank of website. Working knowledge and handling experience of Google Absence and different affiliates account. • Knowledge of Jquery Mobile, Android application development and Phone gap. Experience of Developing and maintaining web base portal or directory website. Work closely with the other team members to meet client goals. Promote on page SEO activities and also the interactions that build ranking, profile and traffic.

Check Also


Download Realty – Unique Real Estate WordPress Theme

Realty is a fully-fledged property management system for real estate agents and companies. Accept free ...

Leave a Reply