WordPress.org

Ready to get started?Download WordPress

Forums

Severe Database Corruption. (3 posts)

  1. Klark0
    Member
    Posted 6 years ago #

    I'm trying to help a friend through this one, but it's stumping me.

    He's got a pretty large wordpress install -> 46,000 posts, 120,000 comments, 12,000 subscribers, 20 cateogies, no tags. The database itself is 450MB at the moment.

    About a week ago, he tried to optimise the database using cpanel. The command failed or stalled, and he had to restart the server to get it back online. On the front-end, everything is working fine and no errors are encountered. On the backend, these things happen:

    - ALL Categories, Comments, Users, and Posts disappear and reappear randomly! This doesnt happen simultaneously. On Dashboard for example, you might see how many comments, but no posts. If you go to edit-comments.php, you see no comments but when you refresh the page they appear. The most annoying effect is probably when Writing Posts, and the categories don't appear.

    - The WordPress "Database Upgrade" notice appears like twice per day when visiting the wp-admin pages. No upgrades is necessary he's already running 2.7. Of course, clicking Upgrade does nothing. Only way to get rid of this is to restart mysql.

    I have tried repairing and optimising mysql via Cpanel and from ssh with 'mysqlcheck' and 'myisamchk' with no success.

    Any suggestions please ?

  2. Saurus
    Member
    Posted 6 years ago #

    Can we assume he has never backed up his database?

  3. Klark0
    Member
    Posted 6 years ago #

    His last backup was 2 years ago :D

    *sigh*

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.