This WordPress tutorial for beginners will tell you that according to DisplayWP and other sources, WordPress originally developed on MySQL, but in 2017, over 5% of all active WordPress installations were using MariaDB.

This WordPress tutorial will further tell you that nowadays, this number may be different, but nonetheless, a WordPress website on MariaDB looks rather simple.

This WordPress tutorial will tell you that depending on what version of the WordPress website you install, you will see 12 or more tables that will most likely be powered with the InnoDB storage engine and have a collation based on utf8mb4.

Behind the WordPress MariaDB database, the user table will feature all usernames, hashed passwords without salts, email addresses, links to user profiles, and more, and this WordPress tutorial will also tell you that the usermeta table will feature information related to users and their actions.

Watch this WordPress tutorial until the end and see that there's the wp_options table that depicts all of the available options within MariaDB and lets you modify miscellaneous settings within your WordPress website.
This WordPress website tutorial will tell you that wp_posts table of your WordPress website will feature all of the posts within your WordPress website and will include information on the author, post date, content, the title, excerpts, the status of the post, whether they're open for comments or not, and so on.

This WordPress tutorial will also tell you that the wp_terms table will contain information on categories available within your WordPress website, and other tables will contain some other information relevant to your WordPress website.

This SQL tutorial will tell you that a WordPress website installs quickly, as well as works on MySQL Server and MariaDB Server alike because its database structure is rather simple.
This WordPress tutorial will walk you through the main concern, too. That for some may be related to WordPress website plugins and these often concern the WordPress MariaDB database with their text, metadata, and settings while continuing to store static files like images, javascript and CSS files in the plugins directory of your WordPress website.

When we look at the deeper functionality of plugins within your WordPress website, we can also notice that certain parts of them pertain to different areas of our database behind our WordPress website.

For example, WordPress website plugins providing a custom post type may act on wp_posts, wp_postmeta, wp_comments and wp_commentmeta tables adding different columns to these tables that may be removed when the plugin is removed from our application, and so on.

All that means that our WordPress MariaDB database is a crucial point for WordPress.
While one can just take and restore a backup onto a new server and spin up the same MariaDB WordPress instance there, many recommend taking database backups with tools that "pack" files and the MariaDB database together and unpack them on our new MariaDB server so we don't have to worry about compatibility or versioning issues, or apps not understanding instructions. That way, our MariaDB WordPress website would be good to go!

Make sure to subscribe to this SQL tutorial channel to learn more about how WordPress interacts with MariaDB, learn more about sql interview questions and answers and things concerning them such as sql injection, cross-site scripting, cross-site request forgery and the like, and until next time.

Music:
Cruising by KV: [ Ссылка ]
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: [ Ссылка ]
Music promoted by Audio Library [ Ссылка ]

#wordpress #mariadb #mysql #sql #database #databases

свернуть