MySQL mangled my wordpress data.

I browsed to dacrib.net only to discover the wordpress initial install screen was being displayed. WTF? It must be the database I thought. Sure enough after running mysqlcheck against it I saw that one of the tables was marked as crashed. So I fixed it.

mysql> repair table wp_options;
+————————–+——–+———-+———-+
| Table | Op | Msg_type | Msg_text |
+————————–+——–+———-+———-+
| xxxx_wordpressdb.wp_options | repair | status | OK |
+————————–+——–+———-+———-+

All better now. Maybe I should set a cron up to do that every few months. Anyway I got a dump in case everything goes to hell sometime soon.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.