Mysql table problems in wp? posts disappeared

  • Hi I am just hoping someone can educate me here. This is the second time in a matter of weeks that I have had a problme that turned out to something going wrong with a db table – repair table from phpmyadmin fixed it both times.

    Different tables, different websites – table shows up in the phpmydamin list as “in use” – whatever that means!

    Also most scarily – since the second time is was the posts table, ALL pages and posts were delivering 404’s – I tried permalinks, but was not that.

    QUESTION:
    what causes this? is it a mysql problem, a hardware problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter anmari

    (@anmari)

    okay I have semi answered myself I guess, Although any advice on how to detect and/or prevent would be appreciated.

    It is either the hardware or a bug in the sql code?

    https://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html

    The mysql site says:
    * The mysqld process is killed in the middle of a write.
    * An unexpected computer shutdown occurs (for example, the computer is turned off).
    * Hardware failures.
    * You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.
    * A software bug in the MySQL or MyISAM code.

    Thread Starter anmari

    (@anmari)

    Found this in the trac
    https://core.trac.www.ads-software.com/ticket/4677 and this
    https://core.trac.www.ads-software.com/ticket/10728

    which seem to indicate that wordpress can detect a corrupt table? If so , seems one really should have some kind of alert sent to the admin user if possible.

    Does any one know if there is a plugin that could send an alert (assuming it can run even if the options table (for eg) is broken? )

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Mysql table problems in wp? posts disappeared’ is closed to new replies.