Join My Mailing List
Learn how to make money online with a blog and instantly download my two free reports.
Why are you searching for the original WordPress MySQL Tables? Let me guess? You’ve been blogging on your WordPress blog for about ten months now, you have around 50 WordPress plugins installed, things have been going slow for a few weeks and now your blog finally kicked the bucket and crashed. Well, don’t worry, the same thing happened to me many times. Your blog is starting to pick up a little bit of traffic, during times when there is a lot of it, seems like your server is on its last leg.
Maybe that isn’t the case at all. Perhaps your WordPress blog just got hacked and you have got it pinpointed down to a WordPress plugin being the cause. Whatever the reason may be, even if it is for no reason, it’s a good idea to always know what the original MySQL tables are in your WordPress database. As of WordPress version 2.6.2. the original database tables are as follows:
- wp_comments
- wp_links
- wp_options
- wp_postmeta
- wp_posts
- wp_terms
- wp_term_relationships
- wp_term_taxonomy
- wp_usermeta
- wp_users
These are the original ten tables in your WordPress MySQL database. If you have more then ten, then the additional tables were created when you installed some various WordPress plugins.
The great thing about WordPress plugins is that they enhance your blog — either for yourself as the publisher or for the reader. WordPress plugins make things easier for people and allow publishers to do certain things with their WordPress blog with out the need to know how to program.
With that said, the disadvantages of WordPress plugins is that some of them add additional tables to your MySQL database. The problem with that is that additional tables in your database can cause your WordPress blog to become unstable and at times even unsecured. Commonly though, a lot of WordPress plugins will cause a MySQL conflict resulting in your WordPress blog crashing.
The reason for this is simply because many of the programmers who create WordPress plugins write the code in a way that doesn’t take into consideration the code that other WordPress plugin developers are writing. Secondly, as WordPress itself updates to newer versions, a lot of WordPress plugin developers fail to provide updates to their plugins to run on the current version of WordPress.
All in all, WordPress plugins are great. However, I would steer clear of using any WordPress plugin that adds additional tables to your WordPress MySQL database. Doing things right, you should investigate each plugin that interests you. Do a Google search to find out what others have said about the plugin. Also, visit the developer’s web site and see if it is active.
It might not be a bad idea to contact the developer as well. Ask him if the plugin adds additional tables to the MySQL database and why. Depending on the response you get — if any — should reflect on your decision to install the plugin you are interested in.
The best thing that you can do to keep your blog healthy and secure is to really limit the number of tweaks, modifications and customizations that you make. The more changes and enhancements that you make to your WordPress blog increase the risk of your blog getting hacked and increase the chances of your blog crashing and failing.
If you would like to learn more about the original WordPress MySQL tables, check out the WordPress.org Database Description page.
Related posts:
- How To Speed Up Your WordPress Blog In May of 2008 I was running into a lot of trouble with my WordPress blog. Traffic was on the...
- The WordPress WP Super Cache Plugin For me, it seems that the WordPress WP Super Cache Plugin is a very necessary plugin to have for blogs...
- The WordPress Google XML Sitemaps Plugin The WordPress Google XML Sitemaps Plugin is an absolute MUST if you run a WordPress blog and are concerned with...
- Wordpress Plugins Poll Comments are requested. If you run a self hosted Wordpress blog, and read this brief article, please take a...
- WordPress Does Not Suck Recently I ran across a post and watched a video of Mark Wielgus rant about how he feels that WordPress...
Tags: Blog Tips, MySQL, MySQL Tables, WordPress, WordPress Database, WordPress MySQL Tables, WordPress Plugins, WordPress Tips
Date/Time: 9-22-2008 03:25:27 Comment #22991
Check out Madhur Kapoor’s last blog post..Create Presentations Online with SlideRocket
Date/Time: 9-22-2008 03:35:46 Comment #22992
With the tables, Just be VERY careful man… you can TOTALLY screw your blog up if you delete the wrong tables.
Be sure to create an entire back up of your MySQL Database prior to doing any changes.
Also, as you delete tables from your database, export a copy of it to textpad, notepad, etc… then check your blog to make sure it is still running. If you crashed your blog, then import the database back into MySQL simply by copying the contents from textpad and pasting it back into the import option within phpmyadmin.
Date/Time: 9-23-2008 17:13:11 Comment #23039
Check out Madhur Kapoor’s last blog post..Create Presentations Online with SlideRocket
Date/Time: 9-22-2008 07:18:40 Comment #22995
Which are the symptoms that your blog is crashing ?
How do I know that’s definetely time that I’ve to go in that scary place called “PhpAdmin” ?
thanks in advance
ciao
alex
Date/Time: 9-22-2008 09:47:29 Comment #22997
I’m curious about why you say that. The number of tables per se—unless we’re talking about zillions—shouldn’t affect your database performance, and most security issues are on the PHP side of things.
Date/Time: 9-22-2008 10:22:18 Comment #22998
I’m looking at my blog and I’d swear I have 30 plugins in there that I’ve tried over time …. they’re still activated but going nowhere.
Check out DOC’s last blog post..Stamp Collecting Tools
Date/Time: 9-22-2008 11:45:50 Comment #23001
I went the easy way and hired CyberCoder to go in and make things work well. That guy is good!
On a side note, what the crap is this Yahoo Pipes thing I am going thru outta the feed reader?
What are you cooking up Garry?
AL
Check out Allyn’s last blog post..Honest Review of the Neuton Battery Powered Mower
Date/Time: 9-22-2008 15:35:47 Comment #23004
Another thing to be careful of is the Wordpress Table Prefix, it throws some people off. The default is wp_, however, depending on your system it can be different.
Example : wp_comments = wp_abcdefg_comments
The [abcdefg] represents part of the prefix assigned to your tables. So each table Garry has listed, will also have the extra prefix as part of the name.
The reason for this is twofold, running multiple blogs on a server and added security If you have just the standard prefix, it is much easier to get hacked, since the default is well known.
Check out David Cooley’s last blog post..Wigix Marketplace
Date/Time: 9-23-2008 13:51:48 Comment #23037
Check out Monty’s Mega Marketing’s last blog post..Top Digg User Zaibatsu = Banned!
Date/Time: 9-23-2008 23:10:45 Comment #23043
Date/Time: 9-23-2008 23:11:24 Comment #23044
Check out Top CD Rates’s last blog post..$700BB - You’ve Got To Be Kidding