Please bear with me as I’m working on doing some final touches on a move to a new web host.
–edit–
Well, it looks like everything is up and operational!
Please bear with me as I’m working on doing some final touches on a move to a new web host.
–edit–
Well, it looks like everything is up and operational!
I have been unsatisfied with my site layout since I launched the domain back in 2006. It was rather simple, but having all of my reviews on one page is getting rather cumbersome. Rather than cut and paste my reviews into unique files I figured that moving to a blog format might be the best move. This will also give me the opportunity to post about things unrelated to what I am currently reading. I’m hoping I can organize things better this way and possibly go back and work on some short story reviews also.
I haven’t yet enabled user comments, but I will as soon as I finish minor tweaking to my template.
Almost three years ago I set out on a massive project to read all 36 of the books in the Robot and Foundation Universe. The main thing that prompted me to start this project was an eBay auction that had a specific book I was looking for (The End of Eternity, which is loosely connected to this project) and several other books which I’ve already read. I purchased about 16 books in a lot for about $35 total. After finding this deal I decided to try and purchase every book in the series, which I eventually accomplished. (more…)
I finally upgraded my WordPress install today, and like a responsible web admin, I backed up my database and also my file tree. After my upgrade I noticed that my comments were all gone! I grumbled a bit and figured I’d extract the files from my backup. I opened my file up and noticed there were no comments. Doh! Where are they? I checked my backup from June, no comments. The latest backup I had with comments included was from February. The phpMyAdmin console showed the table “in use”. Not sure exactly what to do, I opened up a quick Live Chat with my hosting provider, HostGator, and noticed that I was #1 in queue with what, 147 agents available? My problem was fixed in less than 5 minutes. The fix also recovered a few comments that were posted after my last good backup.
I apologize to those of you that tried posting comments the past few months, because they were all eaten up due to the table being locked. I’m not sure what happened, but the support guy told me how to fix it myself if it ever happens again. Essentially, there’s a GUI in the cPanel to check and repair individual databases. I work with MySQL quite a bit at work, but I wouldn’t consider myself a DBA. Now I need to find a better WordPress backup plugin, because I think it should have thrown out some type of error if the table wasn’t readable.
Anyway, I’d like to take this opportunity to recommend HostGator. If you need hosting, please check them out. Any signups done through my link will help pay for my web hosting. Also, you can use code SCIFI25OFF for 25% off your first order. They offer 1 click WordPress installations if you are looking for something like that.
Here are my steps prior to all WordPress upgrades:
Here is how I restore
Do you have a blog? What is your disaster recovery plan?