I put in another long blinking night doing systems administration. Lessons learned…
- Mysql 4.0.x doesn’t like quotes around the database names in the ‘use’ command
- Mysql 4.0.x doesn’t like ‘default charset=latin1′
- Mysql 4.1.x mysqldump outputs both of those – thus requiring use of emacs to make things work when you’re migrating/moving databases between the two.
- SCP rocks
- it’s possible to upgrade the OS of a linode from ubuntu 4.10 to 5.04 (warty warthog to breezy badger) by editing the sources.list file and using apt-get. It works well, but you’ll get awefully tired of staring at the screen with white knuckles before it’s all over.
- Rsync also rocks
- Most people wouldn’t believe how much stuff you can really run on a single linode.
The embedded vieo plugin wp-ExtremeVideo is awesome. I picked it up at Ross Gerbasi’s blog, and it works well. I finally put an FLV file of my Red-Rock canyon video up, so that people may actually see it. (ogg and mpeg are still a PITA for my folks).
I made a bunch of updates to the web server today – mainly to get ready for a large system upgrade. The largest involved cleaning up a number of DNS entries, removing unused functionality and upgrading key components – including a few wordpress installations. While I was at it, i also installed a wordpress plugin to insert inline audio. The major plus for that is that readers don’t need any special software to listen to it, as it comes up right in their browser – like this
I’ve also installed video support for this blog. For example, you can view my Red-Rock Canyon video (lo-res version, of course) below. It’s a nice setup because it doesn’t require anything special on the destination box.