WordPress Database Tip: How to Optimize and/or Repair Your Database
No related posts.
This site is optimized for display on your iPhone
Bigdump
Blackboard
Canvas
Change URL
Custom header
Database
Edit theme
From WordPress Codex
iNove
Install
Instructure
Kubrick
lms
Localhost
Locked out of WP
Manage comments
Moodle
moodle 2.0
Moodle Partner
moodle security
moodle upgrade
Move
Multiple Blogs
Non-Techie
phpMyAdmin
Released Under GPL
sakai
Security
Upgrade
video tuts
wordpress
wordpress.org moderation
WordPress 2.8
WordPress 2.8 Users Guide
WordPress 2.9
WordPress 3.0
WordPress Post
wordpress security
WordPress Themes
WordPress Training
wordpress upgrade
WordPress User's Guide
WP Plugins
WP Themes
XAMPP From WordPress Codex — GPL (15)
Image Editing (3)
Install WP (4)
Just the Video Tutorials (32)
Locked out of WP (5)
Moodle (84)
Move WP (6)
MS Office (2)
MySql DB (2)
Non-Techie (4)
Quotable Tweets (5)
Uncategorized (15)
Upgrade WP (5)
WordPress Mu (1)
WordPress Termonology (1)
WordPress Users Guides (3)
WP 2.9 (5)
WP 3.0 (7)
WP Comments (2)
WP database (5)
WP General (14)
WP Mobile (1)
WP Older (25)
WP Plugins (7)
WP Templates (2)
WP Themes (13)
XAMPP (4)
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
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.