July 2011 – The Science Fiction Review

The Humble Indie Bundle #3The Humble Indie Bundle #3

July 26, 2011| Stettin| 0 Comment| 6:55 pm

It seems kind of odd that I post a review of a Humble Bundle game, then just a few days later, a new one comes out. I’ll keep it short and sweet this time. The Humble Indie Bundle #3 is out with 5 games, name your price. You get a key instantly redeemable on Steam or you can download them directly. I already have Crayon Physics Deluxe from a while back and highly recommend it if you like physics based games. The levels get pretty damn hard, and to be honest I’ve never finished all of them. The other 4 games look pretty cool, so check them out! Proceeds go to any combination you want of the developers, Child’s Play Charity, Electronic Frontier Foundation, or the Bundlers.

One thing I like about the Bundle sales is that all of the games are DRM free and work on PC, Mac, and Linux. Another thing I’d like to add is that if you plan on just donating a penny, Santa is watching!

–Update–

They just added 2 new games and also you get Humble Bundle #2 if you donate above the current average price!

Revenge of the Titans by Puppy GamesRevenge of the Titans by Puppy Games

July 24, 2011| Stettin| 0 Comment| 1:59 pm

Revenge of the Titans is the best tower defense game I’ve played so far. RotT has skill trees that span about 5 different “worlds”. The game plays differently depending on what skill tree you pick. There is a Campaign, Endless, and Survival mode. One thing I did not pay attention to is that Survival mode uses your research tree from the last level in that world. This can definitely impact your Survival Mode times if you were holding off for something critical like barriers until just after the next world. Anyway, I managed to get the top time on survival and held it for a few weeks. Right now the record is around 3 hours (scratch that, 6 now!), which is super hard to do. No, you don’t have to play a level for 6 hours, you can hold down Tab to fast forward the level. So far I’ve done at least 3 playthroughs. Once just after the Humble Bundle, another a few months later just before tank droids were added, then again just after. (more…)

Comments table crashed, HostGator to the rescueComments table crashed, HostGator to the rescue

July 23, 2011| Stettin| 0 Comments| 2:33 pm

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?