Large number of free and premium WordPress plugins simply change values in already existing WP database. Learn about WP #database now.
Did you know that everything inside WordPress is actually a post? So, if you create Post, Page, Attachment, Revision, Custom CSS, Changesets… everythig is stored inside “wp_posts” database, only with different post_type value.
Also, all your users are stored inside “wp_users” database, and all addtional data about these users (profile fields for example), are stored inside “wp_usermeta” table.
So, for example if you have premium or custom theme, and you want to “build” some additional functionality, or simply learn more about your theme, you can simply read trough wp_usermeta and figure out (for example, that your users have additional profile fields such as: gender, city, street address, etc.).
One very important table is “wp_options”, inside which WordPress store lots of important settings. For example, if you are locked out of web site because of corrupted/malicious plugin, only way to return back is to disable this plugin. Problem is, you can’t disable plugin if you can’t open web site backed.
This is easy solvable if you have access to WP database, and run simple query: SELECT * FROM wp_options WHERE option_name = ‘active_plugins’;
This will return array with all active plugins. If you simply delete content of this field (don’t worry, you are only deleting plugin status, not a plugin it self), all plugins on your web site will be disabled. You will be able to enter your web site once again, and then enable only correct plugins.
Do you want to know more about WordPress database? We are preparing interesting blog post about this. Tell us what you want to know? What questions about WordPress database would you like WPMandrake to help you demystify?
Share knowledge and leave your comments below.