Rather then repeat what Jon has already done I simply present you his articles: Part 1: Outlook, Part 2: Google Calendar and Part 3: Apple ical.

Thanks to mydigitallife for the hints on how to do this.

In my case bilbo.some.net was renamed to kinscoe.somenewplace.com.

UPDATE wp_options SET option_value = replace(option_value, 'http://bilbo.some.net',
'http://kinscoe.somenewplace.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_options SET option_value = replace(option_value, 'http://bilbo.some.net',
'http://kinscoe.somenewplace.com') WHERE option_name = 'home';

UPDATE wp_posts SET guid = replace(guid, 'http://bilbo.some.net','http://kinscoe.somenewplace.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://bilbo.some.net', 'http://kinscoe.somenewplace.com');

show tables;
+---------------------------+
| Tables_in_bilbo_wordpress |
+---------------------------+
| wp_categories             |
| wp_comments               |
| wp_link2cat               |
| wp_links                  |
| wp_options                |
| wp_post2cat               |
| wp_postmeta               |
| wp_posts                  |
| wp_usermeta               |
| wp_users                  |
+---------------------------+
10 rows in set (0.02 sec)

SHOW FIELDS FROM wp_options;

+---------------------+------------------+------+-----+---------+----------------+
| Field               | Type             | Null | Key | Default | Extra          |
+---------------------+------------------+------+-----+---------+----------------+
| option_id           | bigint(20)       |      | PRI | NULL    | auto_increment |
| blog_id             | int(11)          |      | PRI | 0       |                |
| option_name         | varchar(64)      |      | PRI |         |                |
| option_can_override | enum('Y','N')    |      |     | Y       |                |
| option_type         | int(11)          |      |     | 1       |                |
| option_value        | longtext         |      |     |         |                |
| option_width        | int(11)          |      |     | 20      |                |
| option_height       | int(11)          |      |     | 8       |                |
| option_description  | tinytext         |      |     |         |                |
| option_admin_level  | int(11)          |      |     | 1       |                |
| autoload            | enum('yes','no') |      |     | yes     |                |
+---------------------+------------------+------+-----+---------+----------------+
11 rows in set (0.04 sec)

select option_value from wp_options WHERE option_name = 'home';
+---------------------------+
| option_value              |
+---------------------------+
| http://bilbo.some.net |
+---------------------------+
1 row in set (0.01 sec)

Note that in this case I was only renaming the virtual host not actually moving the site to another server. If you do that then you also need to backup your database and restore it to the new server as well.

12.5 years ago I put this script together to throw weather displays into my X windows desktop background. Today it still runs however it now runs as a kiosk display only above my desk. Pic here. Amazing how something so simple just continues to keep running without much modification. Occasionally I change or add a URL but for the most part it requires little maintenance.

So there is this dire vulnerability in Adobe Acrobat PDF writer for Windows XP (albeit Microsoft now admits it’s is actually an XP bug) and sure enough an exploit is now in the wild. Sure there is a work around and both Adobe and Microsoft promise fixes at the end of this month. By the way I find it more than a little odd that both companies are fighting over responsibility for this until I considered that Microsoft’s Silverlight product is in direct competition with Adobe’s acquired Flash technology. But fooey on all that I decided this morning. I stupidly paid a bunch of money for Acrobat 6 way back when because it was actually a good and useful product but today I de-installed the printer driver because I found something better.. and of course it’s GNU! It’s called PDFCreator and can be downloaded here from Source Forge. I tried PDFCreator and it works great from Firefox. Unlike Adobe the printer driver remembers the last directory I saved to (I have a master directory where I save my receipts). Here are some screen shots of it in action (click on the thumbnail and then click on Close to return).

I am actively looking for a desktop wiki I can use to post to my online wikis (yet to be published). They both will be where I store my note taking. I will have one for public (world view) and private (family view). Both of course need good security from hacking or defacing content which generally flies in the face of wikis since they are of course supposed to be about collaboration. I have not completely settled on server side software just yet although MediaWiki, PmWiki, UseModWiki and Oddmuse are high on the list. In advance of that I am also looking at wiki desktops that can be used to edit and publish to server side wikis. Some of the desktop tools (”Personal wiki“) I am looking at are Wiki on a Stick, TiddlyWiki and WikiPad, but I am very much in love with VoodooPad unfortunately for me it is only available for Mac.

I also also am looking how to integrate this with a mobile device as a miki.

Some hybrid products I came across include the Chandler Project and IBM AlphaWorks project QedWiki. Download is at http://files.zend.com/qedwiki/. Here is a video of it in use. Interesting but beyond the scope of what I am doing. Plus this appears to be emerging as commercial software.

The wife was hogging the HDTV last night when I got home (grumble, grumble - yes I know Gil. ) anyway since I didn’t have access to the DVR from the computer (I am working on that BTW - Slingbox would have worked here but the XYL was ahem hogging the DVR but I digress..) I thought this would be a good time to try a download on Netflix. Well it did work with no visible burps or streaming problems. It did however require IE 6. Firefox would not work. I happened to have already installed IE 7 some time ago and that worked ok. Basically it downloads this .msi installer. You run this and then apply an update to Windows Media Player and lo and behold your video begins streaming pretty quickly inside of IE. Now the selection is a different story. I first choose Sci Fi as a category and it was uncanny almost everything listed I had not only seen before but had already rated! So right off the selection was not that spectacular. I had wanted to see Minority Report again for some reason but that was not available for download. Bummer! Well we are not off to a great start here. I then decided to cruise based on ratings. And once again almost everything with four stars I had already seen so I kept going down the list by ratings until I hit something I hadn’t seen before (and that I actually would want to see) and I fell upon Dead Like Me. I had heard Glenn Beck rave about this series before so I gave it a whirl. As to my review of the show I will post that later on my entertainment blog eiga.kevininscoe.com.