This demonstration will show you what your WordPress SQL Database looks like behind the scenes and will briefly cover a few tables and show you how to export your wordpress database to a .sql file so that you could have a healthy backup and if you need to, you can use this file to transfer your wordpress blog to a new web hosting provider.
Video Demonstration Here (leave me feedback, I welcome it)
Most people don’t know what is behind the scenes of WordPress, they just use a web hosting providers 1 click install and only ever see the wordpress admin (wp-admin) or maybe plugins and files. To help you understand the WordPress database and how the posts, comments and options are stored here is a list of the default wordpress SQL Tables:
The comments within WordPress are stored in the wp_comments table.
The wp_links holds information related to the links entered into the Links feature of WordPress.
The Options set under the Administration > Settings panel are stored in the wp_options table.
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.
The core of the WordPress data is the posts. It is stored in the wp_posts table.
The categories for both posts and links and the tags for posts are found within the wp_terms table.
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.
This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
Each user features information called the meta data and it is stored in wp_usermeta.
The list of users is maintained in table wp_users.