wp_posts.myi?

  • I have SQL errors all over my blog. https://web.aanet.com.au/skartel/

    I can’t access the wp_posts.myi table through PHPMyAdmin either, it cannot display it.

    What happened was, I was editing a page through wordpress and used the < strong> and < em> tags for the first time – I had never used them before, clicked submit, and my blog didn’t display posts anymore. I don’t see how this could impact on this but it either did, or is just a coincidence and something else is happening.

    Thanks

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

  • That’s a hosting issue – email your support people – only they can help here.

    Thread Starter skartel

    (@skartel)

    My hosting place is my ISP, since I get free, unlimited bandwidth. They don’t really have an idea of what they need to do. Could somebody shed some light on the topic, I would really like to fix this but me and my host haven’t got the foggiest.

    The MySQL database cannot find the files it uses to store your database. w_posts.myi is a file used by MySQL to store your wp_posts table — the table that contains all the data about your posts.

    This may be a permissions issue, or it might be that the file was deleted (or corrupted in some way).

    Your host is truly the only one who can help you, because they’re the ones in control of the MySQL database. They can check file permissions, check disk and filesystem integrity, stop and restart the database, try mysqlcheck to have MySQL verify its tables, etc etc.

    I met these problems twice. First time, I kill all wp database in phpmyadmin, then insert my backup. It is fast. However, I lost a lot of un-backup articles. The Second time, today, I user the REPAIR TABLE WP-POSTS mysql language in phpmyadmin. And it works.

    https://www.ads-software.com/support/topic/68363?replies=8

    (BTW, before I do REPAIR code, I reinstalled my apache server due to phpmyadmin total crashed)

    I think wordpress has a bug. When user is writing his article, if he click the ‘previous’ button of his browser a lot of times. The system got MYI error 145 problem. Especially in IE. Also, if two people are editing same articles. It caused this bug, too.

    If you host support you a phpmyadmin interface, you can easily solve this problem.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wp_posts.myi?’ is closed to new replies.