MySQL Database Corrupt

  • For the last week my site had been crashing for a few minutes because of connection reset errors Ive been getting in my browser. After finally a week of trying to figure out what it could be I’ve believe that the problem could be with the MySQL database set with wordpress. I’ve backed up the MySQL database, and I believe all I need to do is delete it and recreate it with the same name and restore it with the backup I made. Will this corrupt my wordpress blog or will I be able to start off right where I left off?

    These are some of the errors I get

    [10-Aug-2008 21:16:01] WordPress database error MySQL server has gone away for query SELECT ID FROM wp_posts WHERE to_ping <> ” AND post_status = ‘publish’ made by do_all_pings

    [10-Aug-2008 21:16:02] WordPress database error MySQL server has gone away for query UPDATE wp_options SET option_value = ‘0’ WHERE option_name = ‘doing_cron’ made by update_option

    [10-Aug-2008 21:16:25] WordPress database error MySQL server has gone away for query SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘_pingme’ LIMIT 1 made by do_all_pings

    Can these be fixed without deleting and restoring the database?

Viewing 1 replies (of 1 total)

  • I have been having a similar problem for a few weeks and frankly, it is driving me nuts. I am pretty sure I’ve narrowed the cause of the problem down, in part to, a plugin (statpress_reloaded) that is too intensive on the MySQL server (the server load is perhaps my problem).

    Anyhow, I can still log into my CPanel and then I go to phpmyadmin and click on a few random things, perhaps even create and drop a table, and the site comes back.

    Pain in the ass, I know, but for a while I was deleting and reinstalling WP to fix the problem and this is much easier. I’ve disabled the plug-in for now as well and so far so good.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL Database Corrupt’ is closed to new replies.