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:
- Go to your phpMyAdmin either through your host’s control panel or through some other means.
- Select the database that your WordPress blog is using.
- On the home page for that database, there is an Overhead column to the far right that shows the overhead for each table.
- If one of the tables has a large overhead, simply check the box to the far left for that table.
- Then click the drop-down menu that shows “With selected:” and choose “Repair table”.
- 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