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=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.
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.