MySQL mangled my wordpress data.
Thursday, March 20th, 2008
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.