Database Crash – How do i repair

  • Resolved knagles

    (@knagles)


    14 years, 8 months ago

    My Site: https://downtownls.org/dlsblog/

    Hello

    I am getting ready to update a clients website to the newest version of WordPress.

    How ever when i logged in to the admin i saw the following on the Admin Page

    WordPress database error: [Table './downtow_wordpress/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    And i See this error when i look at the comments for an article 

    WordPress database error: [Table './downtow_wordpress/wp_comments' is marked as crashed and should be repaired]
SELECT * FROM wp_comments WHERE comment_post_ID = '177' AND (comment_approved = '1' OR ( user_id = '1' AND comment_approved = '0' ) ) ORDER BY comment_date

    Im told this error has been showing up for some time now but has not impacted the site.

    I tried looking for solutions online and only found one article on how to fix it and that did not work (It said go into phpmyadmin, look for any tables with overhead and repair them)

    If you need more info let me know.

    Thanks
    Kyle

Viewing 7 replies - 1 through 7 (of 7 total)

  • You repaired ALL the tables and not just with an overhead?

    Id repair everything first then try again.

    Thread Starter knagles

    (@knagles)

    Thanks for the quick reply

    I went back in and repaired all the tables. Still showing that error.

    Any other ideas?

    I’m told this error has been showing up for some time now but has not impacted the site

    Who told you that? Your webhost?

    Ask your host if they had a DB backup for you. If not, you need your own for the future: WordPress ? WP-DB-Backup ? WordPress Plugins

    Thread Starter knagles

    (@knagles)

    No my client did.

    I am a reseller for hostgator (We resell webhosting and do webdesign)

    As for the backup would that undo any changes and postings for the last 6+ months? If so, that wont be possable.

    Now that i am managing their site backups will be a primary focus.

    Is there a chance this will fix its self if we upgrade? MY goal is to get them updated to the most current version of word press

    Thanks

    As for the backup would that undo any changes and postings for the last 6+ months?

    What kind of backup are you talking about? Database or theme? A database backup is only as good as the time it was made. If your databse backup is 6 months old, than you’ve lost the last six months of content. Don’t depend on a client to do their own backup.

    You’re confusing the three critical aspects of WordPress: design, administration and content. 1) Design is the theme. You back that up and update that differently than the content, which is the database. Copy the theme via FTP to backup. 2) Administration is WordPress itself. Updating WordPress may impact your theme (i.e., new functions that are available in WP3) but isn’t necessarily going to repair a database. It can’t do everything that say, phpmyadmin can do. 3) Content are posts and pages, etc., and are in the database. That’s why you can change themes without loosing content. You database backup is done differently than the theme.

    Thread Starter knagles

    (@knagles)

    What kind of backup are you talking about? Database or theme? A database backup is only as good as the time it was made. If your databse backup is 6 months old, than you’ve lost the last six months of content. Don’t depend on a client to do their own backup.

    Turns out the backup we have(mysql database) is from sunday. So this backup will have the same issue in it. So forget about restoring the backup, lets see if we can fix it.

    You’re confusing the three critical aspects of WordPress: design, administration and content. 1) Design is the theme. You back that up and update that differently than the content, which is the database. Copy the theme via FTP to backup. 2) Administration is WordPress itself. Updating WordPress may impact your theme (i.e., new functions that are available in WP3) but isn’t necessarily going to repair a database. It can’t do everything that say, phpmyadmin can do. 3) Content are posts and pages, etc., and are in the database. That’s why you can change themes without loosing content. You database backup is done differently than the theme.

    I do understand the difference as i work in joomla alot and it has the same aspects.

    All i am trying to do is update the site to 3.0 and keep all postings. It seems to me that the issue is with comments, We are fine with losing those.

    If you go to the site you can see the theme we have is the defult one anyways so upgrading to 3.0 and haveing a new theme is also ok.

    My question is this.

    Can i either fix this error and upgrade to 3.0

    OR

    Will upgrading to 3.0 overwrite the bad entry(s) in the database.

    Thank you

    Kyle

    Thread Starter knagles

    (@knagles)

    Ok i fixed it.

    The SQLDatabase is not being hosted on my server its still on the old one. That is why repairing it would not work.

    Why its still on the old server i dont know but now i should be able to move it ok.

    Thanks for all your help

    Kyle
    ??

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database Crash – How do i repair’ is closed to new replies.