I was lucky with my rebuild this week at Blogger Extreme. Could have been a lot worse. I was able to re-build the MySQL tables instead of the entire MySQL Database. Here’s how I did it.
WordPress builds 10 tables when you install WordPress 2.8. I think they have 11 now with 3.0.1. These tables should be understood so that you can work with them at a future date. I’m not real big on using the different WordPress plug-ins that let you work with the database in one shape, way, or form. After all this is the brain to the Blog. I like to go hands on with the database and while I’ll admit it really is no fun at all, with a little work and concentration you can work effectively with this database software affectionately know as MySQL.
Here is a run down on the tables and what they do! ………. (Man, I wish the editors would hurry up with the WordPress Secrets project!)
- # Structure wp_comments
- # Structure wp_links
- # Structure wp_options
- # Structure wp_postmeta
- # Structure wp_posts
- # Structure wp_terms
- # Structure wp_term_relationships
- # Structure wp_term_taxonomy
- # Structure wp_usermeta
- # Structure wp_users
1. Comments: Stores all the comments that other’s make to your Blog Posts.
2. Links: wp_links table is used to store the blogroll – your Blogs or Websites list of links.
3. Options: All of the different options and selections for your Blog such as URL, E-Mail Address, etc.
4. Postmeta: This table is used to store custom field names and values and other information about your posts.
5. Posts: This table stores all of the Blog Posts that you write for your Blog.
6. terms: To categorize and manage posts and other contents, WordPress uses various taxonomies like categories, tags and link categories.
7. term-relationships: The wp_terms_relationships includes two numbers – a term id and a post id. By grabbing every term that uses a post’s id, WordPress can immediately identify all of the appropriate categories and tags to use.
8. term-taxonomy: In the wp_terms_taxonomy field, each “term” is defined as either a tag or a category.
9. Usermeta: You can keep all sorts of things for each registered user here, birthdays, contact information, etc.
10. Users: WordPress uses this to store registered users. User ID, login, encrypted password, full name, registration date, and things like that.
Sign Up To Receive Breaking News & 
I understand that this is not good material for . I was seeking this certain information for a long time. These tables should be understood so that you can work with them at a future date. After all this is the brain to the Blog.Great post. I was checking constantly this blog and I am impressed! Extremely helpful information specially the last part I care for such information much. I was seeking this certain information for a long time. Thanks and good luck.
I understand that this is not good material for . I was seeking this certain information for a long time. These tables should be understood so that you can work with them at a future date. After all this is the brain to the Blog.Great post. I was checking constantly this blog and I am impressed! Extremely helpful information specially the last part I care for such information much. I was seeking this certain information for a long time. Thanks and good luck.