What to do when Wordpress CRASHES and needs to be repaired

Discussion in 'WordPress' started by wiseassoffice, Jul 31, 2007.

  1. #1
    I just visited my own site a while ago only to be greeted with the dreaded "your db is marked as crashed and should be repaired" on my Wordpress based blog. Of course I had backups but my first instinct as it always should be is to actually try and repair the problem.

    I wrote an article at my site about it and the cure, see link below.
    http://www.noheat.com/2007/07/31/wordpress-is-marked-as-crashed-and-should-be-repaired/

    Hopefully everyone here backs up up their blogs, even if you use a hosted blogging tool such as blogger, see the link there are solutions.

    If you do get the error this is how to fix it, and it is a pretty common error so hopefully when someone needs it this post is here for you. I would be happy to walk you through fixes also so PM if you are stuck. There is so much information out there saying you up the creek and this is not necessarily true. Also because Google crawls the error code it can be difficult to search for a solution.

    Remember to back up your blog!
    PS Yes all is good with my site.

    Chris
     
    wiseassoffice, Jul 31, 2007 IP
  2. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,200
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #2
    Never had that error message before. I have the Wordpress Database Backup plugin installed just in case of an emergency though!
     
    dcristo, Jul 31, 2007 IP
  3. mjesales

    mjesales Peon

    Messages:
    326
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    just login to phpmyadmin and select all the tables in the database then hit "repair" and just run the repair command in mysql
     
    mjesales, Jul 31, 2007 IP
  4. ichigo

    ichigo Well-Known Member

    Messages:
    2,913
    Likes Received:
    116
    Best Answers:
    0
    Trophy Points:
    135
    #4
    i got this error message on one of my mini sites. it appears just above the header. heres the complete error msg.

    SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

    screenshot.

    [​IMG]

    tried to repair it w/ the instructions above but its still there.. :(
     
    ichigo, Jul 31, 2007 IP