Overhead, Crashing, and Backups

If you visited Project Saber this morning you would have seen that it contained no posts or comments.

Apparently the “wp_posts” table in the SQL database for this blog crashed while I was sleeping. After a bit of research, I found out this happens when the overhead for a table becomes too big. It just happened to coincide with the new theme change. So for fellow bloggers out there, here’s what you do to prevent this from happening:

  1. Go to your phpMyAdmin either through your host’s control panel or through some other means.
  2. Select the database that your WordPress blog is using.
  3. On the home page for that database, there is an Overhead column to the far right that shows the overhead for each table.
  4. If one of the tables has a large overhead, simply check the box to the far left for that table.
  5. Then click the drop-down menu that shows “With selected:” and choose “Repair table”.
  6. Repeat steps 4 and 5 for every affected table.

Checking the overheads around once a month would be a good idea.

Now for those of you like me that have a crashed table on their hands, simply select that table and repair it via the above steps and you’re good to go.

This little incident has given me a reality check on the state of my backup system. You should always have backups prepared just in case things spiral out of control.

I use an aptly named WordPress plugin called WordPress Database Backup. I have it set to create a daily database backup to send to an email account I have reserved specifically for this purpose. Then every month I make a zipped copy of the Project Saber folder located on my web server and save it as a backup on one of my hard drives.

My web host keeps their own backups as well, but I like to be on the safe side. This way I can quickly restore my blog if any issues arise.

Hopefully this helps anyone that encounters the same problem and sorry for the blog being temporarily broken. Write on!

Image Source: pixiv

4 Comments to “Overhead, Crashing, and Backups”

  1. Yi says:

    Thanks for the tips. I’ll remember this for when I eventually self host. ^ ^
    I’m sure this will be helpful for many other bloggers right now too.

    [Reply]

    Reltair Reply:

    No problem. I’m glad that it has, or will, help. ^^

    [Reply]

  2. Shazzsteel says:

    I see what you kinda did there with the tenshi pic 😛

    [Reply]

    Reltair Reply:

    Tenshi ftw! 😀

    [Reply]

Leave a Reply

(required)

(required)