Well, it looks like I have reach the approximate half way point in my major project. I’ve just finished Aurora, and am looking forward to getting to books written by Asimov again soon. I am hoping that I will be finished by this time next year at the very latest. I don’t think it should be a problem since a lot of the older books by Asimov aren’t terribly long. I’m finding it interesting how many plot points I have forgotten over the years since I’ve read most of these books already. Hopefully this page will serve as a reference to other people as well as myself in the future.
Milestone
Categories:
Related Post
Comments table crashed, HostGator to the rescueComments table crashed, HostGator to the rescue
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:
- Backup Database via Plugin, also can be done through phpMyAdmin
- Open cPanel and through File Manager, copy my WordPress directory “/installdir” to another directory like “install2011backup”. I think you can only do this quickly if your blog is not installed directly into the root / – note, this takes just SECONDS, rather than downloading thousands of individual files
- Run upgrade, hope for the best
Here is how I restore
- Restore Database via phpMyAdmin
- rename install directory to /install-bad
- rename backup directory from /install2011backup to /install
Do you have a blog? What is your disaster recovery plan?
So I have been a bit behind with my reviewsSo I have been a bit behind with my reviews
I’ve been a bad reviewer lately. I usually try to write my reviews right after viewing or reading but I haven’t had as much time to write them lately. I’ve been playing World in Conflict quite a bit lately, which competes with my reviews here. I should actually do a review for that sometime, since I spend so much time playing it. It takes place in an alternate reality where the Soviets invade the US in 1990. For more information in the meantime just click the link above.
So, here are the things I have watched so far, but have yet to review:
- Blade Runner – The Final Cut
: (I’ve watched the movie, which was awesome, but I still have to work through the rest of the special features on the last disc)
- I am Legend (2007) – I’ve actually watched this twice, once with my Father while on vacation, and again with my wife
- Battlestar Galactica: Razor – Unrated Extended Edition
I’m also in the process of reading two books: Children of Dune by Frank Herbert
My next major milestone will be to read Chaos Theory, Asimov’s Foundations and Robots, and Herbert’s Dune: The Fractal Aesthetic of Epic Science Fiction
That should keep me busy for a little while.
Comments enabled, RSS liveComments enabled, RSS live
Comments are enabled – I’ve enabled user registration (it takes just 30 seconds), so please register if you have the time. WordPress usernames are case sensitive, so keep that in mind when creating accounts and logging in. I look forward to seeing comments, however you don’t need to create an account to post a comment.
Also, I think I’m pretty much done fiddling with the site layout. I’m probably going to play around with the logo a bit and add a few more things to the right sidebar. I’ve also registered with Technorati and Feedburner to distribute RSS feeds.