repairing a mysql table


I have run into some database problems over the years, but had to do something different today when I saw that this site had a problematic table (wp_posts). When I looked at the issue first, I got the message “MySQL error code 145 = Table was marked as crashed and should be repaired”.

To repair a table, I have run (at a mysql prompt in the command line): REPAIR TABLE wp_posts; but today that did not work. After doing some research, I finally was able to fix the table by using: myisamchk -r wp_posts (see documentation. This was a lifesaver!

One thought on “repairing a mysql table”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Serenity Now! WordPress

Internet Explorer and Custom 404 Page Issues in WordPress

Has anyone else seen the issue where you have created a 404 (or not) for WordPress and when you show links to posts or pages in WordPress that are marked as private – IE users intermittently get the generic IE 404 page? I cannot figure out how to fix this. Any thoughts would be appreciated! […]

Web Development

don't overlook bbpress!

It has been awhile since I worked with bbPress (lightweight, fast, and secure forum software), but I recently finished up a small project working on a custom theme for bbPress. If you are looking for forum software, and better yet – and also use WordPress – bbPress might be a good solution for you. There […]