• Skip to primary navigation
  • Skip to footer navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

WP Fangirl

WordPress Consultant Sallie Goetsch

  • speakerdeck icon
  • Home
  • About
  • Why WordPress?
  • How I Work
  • Portfolio
  • Services
  • Blog
  • Contact

How to Repair and Optimize Your Database in WordPress 2.9

January 10, 2010 by Sallie Goetsch 2 Comments

This feature seemed especially likely to be useful to me for my older blogs, the ones that had gone through imports and exports and lots of different plugins. At first I wasn’t sure what you were supposed to do besides pasting the code define('WP_ALLOW_REPAIR', true); into your config.php file. (And when I pasted it the first time, I messed up, because for some reason I had backticks in there instead of straight single quotes.)

I found the answer in Technosailor’s 10 Things You Need to Know About WordPress 2.9 post. After you update your config.php file, you need to visit a special URL in order to run the repair script. That URL is http://yourdomain/yourWPinstalldirectory/wp-admin/maint/repair.php.

Once you get there, you’ll see the following message:

database-repair

I hit “Repair and Optimize” and was pleased (if mildly surprised) to see that all my tables were both okay and optimized already.

After the script finishes running, you get this message:

Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.

define('WP_ALLOW_REPAIR', true);

You might want to just comment the line out so it’s ready for you next time you want to run the script.

Related Items

  • backup in progress
    WordPress Database Backup
  • Database check and repair tools in cPanel
    Checking and Repairing Your WordPress Database
  • photo: man and woman holding smartphones
    WPtouch, WordPress MobilePack, and WordPress Mobile Edition

Share this post:

Share on Twitter Share on Facebook Share on Pinterest Share on LinkedIn Share on Email

Filed Under: Using WordPress Tagged With: WordPress Database

Reader Interactions

Comments

  1. Ricardo says

    November 6, 2010 at 7:29 am

    Can you please tell me where exactly to paste the define code in the config file? I cant seem to get this right.

    Reply
    • Sallie Goetsch says

      November 6, 2010 at 8:34 am

      It should be fine anywhere on its own line. (I admit it’s been about a year since I did this.)

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

What I Write About

  • Book Reviews
  • Content Strategy
  • Design
  • Hosting and Servers
  • Most Valuable Plugins
  • There's a Plugin for That
  • Using WordPress
  • Widgets
  • WordPress Consulting
  • WordPress Events

Series

  • Interviews (5)
  • Checking Up on Your Website (4)
  • Client from Hell (5)
  • WordCamps (17)
  • WP-Tonic Roundtable (30)
  • Modern Tribe Tutorials (13)

Follow Sallie on Twitter

    Sorry, no Tweets were found.

RSS Latest News from the East Bay WordPress Meetup

  • Does It Work? Using The New CSS Layout with Rachel Andrew
    Things change rapidly in the WordPress world. The content in this post is more than a year old and may no longer represent best practices.Description Over the past two years, […] The post Does It Work? Using The New CSS Layout with Rachel Andrew appeared first on East Bay WordPress Meetup.
  • Speaker Training
    Get the workbook and slides for the October 2019 speaker training, plus background and pro tips. The post Speaker Training appeared first on East Bay WordPress Meetup.
  • SEO Audit Template & Resources
    Our November speaker, John Locke, graciously provided a template for an SEO audit report. You can download it as a Microsoft Word or PDF document. The post SEO Audit Template & Resources appeared first on East Bay WordPress Meetup.

Footer

Contact Info

2063 Main St #133 · Oakley, CA 94561

+1 (510) 969-9947

author-izer

sallie [at] wpfangirl [dot] com

Location

Map of East Contra Costa County

I live in Oakley, CA and run a WordPress Meetup in Oakland, CA. Don't confuse them!

Subscribe for New Posts

  • Since I blog on an unpredictable schedule, you might want to subscribe by email. I'll also send out occasional announcements about events.

  • Privacy Policy: I will never sell or rent your contact information.

  • This field is for validation purposes and should be left unchanged.
  • Contact
  • Colophon
  • Comment Policy
  • Privacy Policy
  • Five for the Future

Copyright © 2023 · Utility Pro on Genesis Framework · WordPress · Log in

MENU
  • Home
  • About
  • Why WordPress?
  • How I Work
  • Portfolio
  • Services
  • Blog
  • Contact