WordPress Database Tip: How to Optimize and/or Repair Your Database
No related posts.
This site is optimized for display on your iPhone
Posting tweet...
Backup WP
Bigdump
Change URL
Custom header
Database
Database Error
Deactivate plugins
Edit theme
From WordPress Codex
iNove
Install
Kubrick
Large database
Localhost
Locked out of WP
Manage comments
Moodle Partner
moodle security
Move
Multiple Blogs
Non-Techie
Optimize
Password
Patch vs Fix
Photoshop
phpMyAdmin
Plugin Review
Post page
Redirect WP
Released Under GPL
Remove comments
Security
Static page
Upgrade
wordpress.org moderation
WordPress 2.8
WordPress 2.8 Users Guide
WordPress 2.9
WordPress Post
WordPress Training
WordPress User's Guide
WP 2.7
WP Plugins
WP Themes
XAMPP Backup WP (1)
From WordPress Codex — GPL (16)
Image Editing (4)
Install WP (3)
Just the Video Tutorials (32)
Locked out of WP (5)
Moodle (6)
Move WP (4)
MS Office (1)
Non-Techie (5)
Training (1)
Uncategorized (3)
Upgrade WP (9)
WordPress Termonology (1)
WordPress Users Guides (3)
WP 2.9 (6)
WP 3.0 (1)
WP Comments (2)
WP database (5)
WP General (3)
WP Plugins (4)
WP Templates (3)
WP Themes (13)
XAMPP (2)
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
Thanks for this video!
I had a problem with my Wordpress installation where it showed the “Installation” screen even though Wordpress was installed.
Repairing the database did the trick!
Good thing it was on my local box as well.
-Ray
You’re welcome…glad it helped.
Definitely a very helpful video, but I’m surprised that you’ve left wp_ as your database table prefix. Don’t you feel that it’s a security issue?
This tutorial totally saved me after hours of research. I wasnt able to activate or deactivate any of my Wordpress plugins. Turns out my WP-Options table needed to be repaired. Thanks!
@gestroud: Everyone is entitled to their opinion….even if they are wrong
As long as you have good server security and a good MySql name, username, password, then the table prefix doesn’t mean a “hill of beans”…if I follow that logic then I guess I should rename all the tables since everyone knows what they are in every WP install? If the table prefix is the only thing stopping someone from hacking you site, then that’s not going to stop anything.
No, it’s not a security issue…if someone can access you database by knowing the table prefix, then you have more problems than a table prefix
Of course, you make a good point…it never hurts to change them if it makes you feel better.
@figaro
You definitely have a point there. I’m thinking more along the lines of people who are on shared servers, where security might be in question. Not everyone can afford dedicated servers or run their own home servers.
@gestroud: If you are using a reputable shared host, then it shouldn’t be a problem…if your shared host isn’t reputable, then this is the least of you worries