The database is an important a part of a WordPress website. WordPress uses the MySQL management system and requires MySQL version 5.6 and better. It also works on MariaDB version 10.1 or greater. MariaDB may be a fully GPL licensed fork of MySQL, which will be used as a drop-in replacement for MySQL. Here is a guide to WordPress Database.
A database is made whenever you build a WordPress website. Everything on your WordPress website, be it posts, custom post type, pages, comments, and even settings are stored during a database. It’s sort of a warehouse of data. All of your data is placed in an organized manner in order that it’s easy to seek out them. a picture of a typical warehouse that involves mind is that of rows and rows of cardboard boxes. The boxes are kept on storage shelves. During a WordPress database, the shelves are referred to as tables.
There are 11 tables available by default on a WordPress website. In this guide to WordPress Database, be informed that every table can store only specific data. as an example, the wp comments table captures all information left by an individual commenting on a post like IP Address, comment author slug, etc. Storing data during a specific table makes it faster and easier to seek out them.
A fresh WordPress website has 11 tables. They are listed guide to WordPress Database:
Many of the tables are associated with each other. One piece of knowledge is often associated with other data, as an example, a post is often related to categories and tags. Therefore, the table that stored blog posts will share a relationship with the tables where category and tags are stored.
wp_posts table stores anything content related data of the website. All posts, pages, their revisions are available within the wp_posts table. it’d be confusing but WordPress stores far more into that table. This table also contains navigation menu items, media files and attachments like images and content data that are employed by plugins.
The wp_terms table stores not only categories for both posts and pages and it also stores tags for posts. Links associated with categories also are present here.
The table wp_options is one among the foremost important WordPress database table and stores all the settings of a WordPress site just like the URL, the title, installed plugins, etc. Most of the plugins store settings during this table also. All the settings that you simply see within the WordPress dashboard are stored during this table.
wp_users is what stores all the registered users on the WordPress site. It contains basic information of a user sort of a username and encrypted password, email, time of registration, display name, status, and a couple of more fields.
wp_usermeta saves the metadata (i.e. additional data) of users. It extends the table wp_users with more data. As an example, the primary name of a user is stored within the table wp_usermeta rather than the table wp_users. There are two important fields during this table. WordPress plugins can store some custom data in wp_usermeta by just adding new meta_key values.
Stores descriptions of categories, tags and certain links related to categories.
Terms are items of a taxonomy wont to classify objects. Taxonomy what? For instance , when creating a post in WordPress, by default you’ll add a category and a few tags thereto . Both ‘Category’ and ‘Tag’ are samples of a taxonomy, basically how to group things together.
The wp_term_relationships table helps maintain relationships. As an example, during this post, the one that you simply are reading, is related to a couple of tags and a category. The wp_term_relationships table helps maintain this association.
Links are powerful. they’re like letters of advice. Up until a couple of years ago, blogrolls were fashionable. A blogroll may be a list of external links that appear within the sidebar of an internet site. Back then, WordPress believed that site owners will choose wisely when linking to a different website.
Both approved and unapproved comments left on your posts and pages are stored during this table. Specific data about the author just like the author name, email address, sort of comment (whether it’s an easy comment, pingback or trackback) also are saved during this table. Furthermore, it’s important to notice that if you’re employing a third-party comment service like Disqus, comments won’t be stored during this table, they’ll be saved on the commenting system’s own server.
Extra data about the comments left on your website like which post is that the comment related to are stored here. That’s the ultimate table within the WordPress database of a replacement website. It’s important to notice that if you’re checking the database of an old website, there’s sure to be quite 11 tables.
The longer you hung out running an internet site, the more information you add. As a result, your database becomes bigger. New tables are added to the database to support certain functions on an internet site. Gravity Forms, for instance, creates its own WordPress database table once you put in it on your website. However, not all the WordPress plugins available add tables to the database. Many utilize those already present. Feel free to check us out on all our social media platforms.