midtoad's blog

Oops - hammered my old blog

My old blog is at midtoad.homelinux.org/wp/. This morning I tried to check a story on it, and the blog page wouldn't appear. Hmm. When I tried to do anything with the blog, such as log into the admin function, I kept getting errors, in particular sql error 28. The handy on-line mysql manual said I could execute a repair command on the database, so I tried that on a couple of tables that failed an integrity check. The repair command never completed though, so I aborted it after several minutes. Then I logged into mysql at the command line, and got an error message saying that the tables I'd tried to repair were empty. Oops!

Then I noticed that I had no space left on my hard drive. How could that be? WTF? My mailbox was 50 MB in size, so I deleted all of the messages. Then I recalled that I'd recently tried to upload a 10GB file to my webserver for a friend, and my hard drive is only 10 GB in size. Yep, that'll do it! After deleting it, I was back to a more manageable amount of free space.

I was able to repair my database by extracting the relevant sql statements from my database backup file (you DO back up your databases, don't you?). All is well, and you can now read my old blog again. Whew!