Forums

database corrupted for no reason (3 posts)

  1. gleek
    Member
    Posted 2 years ago #

    today, i got an email from my WP installation telling me that i had setup a new blog, but i hadn't! in fact, it was my old blog resetting itself since two tables in the database got corrupted. the two tables in question were: wp_options & wp_usermeta.

    i managed to fix these (and upgrade to 2.9.2) by restoring a new DB to an old version, copying those tables, and importing them into the DB with all the newest data thereby fixing those tables.

    regardless, how the heck did this happen? why would these two tables suddenly become corrupt? did someone try to hack in and change the information? are there files that, once done with installation/updating, should be deleted from the server to provide extra protection? (i know that you delete files from the server with movabletype because that's what i used before switching to WP.)

    i would like for this to not happen again. thanks!

  2. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    how the heck did this happen? why would these two tables suddenly become corrupt? did someone try to hack in and change the information?

    Try asking your hosting provider these questions.

    are there files that, once done with installation/updating, should be deleted from the server to provide extra protection?

    Not as far as I know. Try reviewing Hardening_WordPress

  3. Samuel B
    moderator
    Posted 2 years ago #

    mysql tables can be corrupted for no reason - it's not a sign of a hack
    if you optimize your tables regularly, you can avoid this to a certain extent
    I would advise running a repair on the 2 tables in question regardless that you imported new info

Topic Closed

This topic has been closed to new replies.

About this Topic