Home > Just the Video Tutorials, WP database > WordPress Database Tip: How to Optimize and/or Repair Your Database

WordPress Database Tip: How to Optimize and/or Repair Your Database

January 22nd, 2009 Leave a comment Go to comments

Get Noticed with a $7.99 .CO!
  1. January 26th, 2009 at 14:12 | #1

    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

  2. January 26th, 2009 at 16:21 | #2

    You’re welcome…glad it helped.

  3. gestroud
    February 13th, 2009 at 00:54 | #3

    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?

  4. February 14th, 2009 at 23:40 | #4

    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!

  5. February 15th, 2009 at 09:30 | #5

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

  6. February 15th, 2009 at 09:32 | #6

    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.

  7. gestroud
    February 15th, 2009 at 18:09 | #7

    @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. ;-)

  8. February 17th, 2009 at 14:55 | #8

    @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 :-)

  9. canli tv izle
    October 3rd, 2010 at 17:31 | #9

    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.

  1. May 4th, 2013 at 12:40 | #1
*