WordPress SQL Demonstration
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
Try out our free cisco training and latest 642-515 training courses to get high flying success in final SK0-003 & mcpd exams; itil v3 certification is also very useful tool.
Related posts:
- Video Demonstration: Optimizing Your WordPress Posts for SEO Video demonstration to walk you through how to use All in One SEO Pack and Google Adwords to find and...
- 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...
- 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....
- Demonstration: Using Google Docs Form as your WordPress Contact Form Screencast presentation on creating a Google Docs form and embedding it in your wordpress blog to use as your contact...
- WordPress 2.9 Features and Functionality Improvements Keith Dsouza from Weblog Tools Collection did an excellent write up showing off the new features of Wordpress 2.9 beta...
This was an excellent video and I am really glad you put it out there. I really liked that you recorded action in it so I can see what you are doing. I'm going to look around here some more to see what else I can learn. You've built a good blog!
Regards
David
- spam
- offensive
- disagree
- off topic
Like