I added all the users from the old web site to this web site, and notified all the users of the change. There were 41 users and I figured it would be easy to cut the data out of my old database dump and create Insert statements to update the new database. I was wrong.
I ended up creating 451 SQL statements to update the new database – 1 for each user in one table, and 10 for each user in another table. This is called brute force and awkwardness, and it leads to errors (of which I had several).
The next content I add will be the old blog entries. Since there are over 600 of them, and since I have to update two tables, I will not be writing individual Insert statements for them. Instead of over 1200 SQL statements, I will write two SQL statements that are much more sophisticated. I will back up the database before I do anything, of course.
Silly sign of the day:
Free/Open Source Software
- The Tao Of Linux
- Ubuntu Linux Is an Ideal Windows Replacement
- Novell “Forking” OpenOffice.org
- Linux adoption – it’s the ecology stupid!
- Open source will attain acceptance in ‘07: Unisys
- Open Document Format published as ISO standard
RIAA/MPAA/BSA/FCC
- The most dangerous download of all – But his kids are special, so they won’t get sued.
- Film pirate gets seven years
- Florida boasts software piracy whistle-blowers
- RIAA v. Barker Showdown Slated for January
Stupid Patent Tricks, DRM and Other IP Nonsense
- TracFone to challenge cell phone unlocking rule
- Will Red Hat Lose Customers Over Patent Protection?
- DRM blanket goes mobile
- Japan group seeks YouTube copyright system
Other News
- Bush: ‘I’m not happy’ about Bolton’s resignation – That makes one of us.
- CIA Veteran: How Robert Gates Cooked the Intelligence
- Vista is the last of the dinosaurs
- Ten things to consider before taking the Vista plunge
- Five reasons not to upgrade to Office 2007
- GAO report finds little competition, higher prices in deregulated markets – Well, Duh!
- Voting machines: Federal Panel Rebuffs Guidelines That Insist on a Paper Trail
Security/Our Rights
- Phishers Attack MySpace with QuickTime Exploit Worm
- Company accused of selling fake antispyware settles suit
- FBI counterterrorism expert “blackballed”
Big Brother