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:
wp_comments
The comments within WordPress are stored in the wp_comments table.
wp_links
The wp_links holds information related to the links entered into the Links feature of WordPress.
wp_options
The Options set under the Administration > Settings panel are stored in the wp_options table.
wp_postmeta
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.
wp_posts
The core of the WordPress data is the posts. It is stored in the wp_posts table.
wp_terms
The categories for both posts and links and the tags for posts are found within the wp_terms table.
wp_term_relationships
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.
wp_term_taxonomy
This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
wp_usermeta
Each user features information called the meta data and it is stored in wp_usermeta.
wp_users
The list of users is maintained in table wp_users.
-Dragon Blogger
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)
<object width=”500″ height=”405″><param name=”movie” value=”http://www.youtube.com/v/l3isTBUHkrI&hl=en_US&fs=1&&ap=%2526fmt%3D18color1=0x3a3a3a&color2=0×999999&border=1″></param><param name=”allowFullScreen” value=”true”></param><param name=”allowscriptaccess” value=”always”></param><embed src=”http://www.youtube.com/v/l3isTBUHkrI&hl=en_US&fs=1&&ap=%2526fmt%3D18color1=0x3a3a3a&color2=0×999999&border=1″ type=”application/x-shockwave-flash” allowscriptaccess=”always” allowfullscreen=”true” width=”500″ height=”405″></embed></object>
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:
wp-usermeta
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_term_relationships
wp_term_taxonomy
wp_terms
wp_users
Related posts:
- Migrating WordPress Blog to New Hosting Provider Part 1 – Backing Up Backing up your existing Wordpress Blog SQL Database and files is crucial to moving it to your new hosting provider....
- Backup Your WordPress Blog Often After hearing the horror story of one of my twitter followers, I had decided to make sure I was backing...
- Optimize your WordPress Database with WP-Optimize WP-Optimize is a fantastic plug-in for Wordpress that allows you to cleanup and optimize your Wordpress SQL Database without logging...
- Adding A BlogNetAward Widget To Your WordPress Blog My friends over at BlogNetAwards enjoyed my “How to vote” video demonstration and asked that I create another demonstration showing...
- My First Time Using WordPress Automatic Upgrade Plug-In I had downloaded the “WordPress Automatic Upgrade” Plug-in because I did want to simplify wordpress upgrades since I had never...
| via FaceBook, Twitter, RSS or Email |  |
Enter your email and subscribe now!
Tags: about wordpress database, how to use wordpress, how wordpress works, tables for wordpress, training for wordpress, understanding wordpress, understanding wordpress database, video demonstration, wordpres, wordpress behind the scenes, wordpress default tables wordpress database info, wordpress demonstration, wordpress sql, wordpress sql tables, wordpress tables, wordpress training, wordpress training video
December 12th, 2009 at 2:40 am
Can you give a more information on how comments work? I am trying to retrieve information from some backups (for some reason my mysql comments table completely erased itself…) but when I open the files, I can only see the comment itelf – where is the information about which post it is associated with etc – or is that a foreign key?
does WP store a backup automatically anywhere?
And finally do you know what the wordpress.sql file is?
Thanks!
[Reply]
December 12th, 2009 at 8:34 am
the comments database table wp-comments stores the comment plus what post the comment is tied to.
[Reply]
December 12th, 2009 at 10:31 am
Great thanks.
looks like i’ve lost all my comments because of some mysql bug…
basically, out of nowhere, one day, the comments table was simply empty.
do you know if wp stores a backup automatically?
[Reply]
December 12th, 2009 at 2:49 pm
By default your database is not backed up, you need to make sure you install a sql backup plug-in like wp-backup or another one so that you can schedule routine backups of your database.
[Reply]
June 20th, 2010 at 6:11 pm
Awesome. Had been fighting with some plugins for WP to backup my data. This is much easier!
[Reply]