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

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)
<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=0x999999&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=0x999999&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

Pass your oca dumps in first try by using our guaranteed Pass4sure 640-864 & Testking 1z0-053 tutorials and best quality Actualtests 400-051 dumps along with HITACHI.

Justin Germino
I have been obsessed with computers, tech, gadgets and games since the early 1980's having grown up on the Commodore 64 and Amiga computers. By day I work in the IT Security Industry and have been in IT for over 20 years. On my spare time I am a Vlogger, Blogger, Streamer, Gadget Reviewer, affiliate marketer, influencer and entertainer. I am also an avid movie fan, TV Show fan, Anime fan, video game fan and fan of trying anything and everything new.
Justin Germino

@dragonblogger

Content Creator/Owner of https://t.co/iWP6afuOc9 for Tech, Game, Entertainment and streamer at https://t.co/594fXMdMIA
HTC VIVE Offers Special Spooky Bundle for Halloween https://t.co/cb1GBzIEMW - 9 hours ago
Justin Germino
Justin Germino
Share Feedback We Want to Hear From You