Man, getting my “emerge -uvDp world” email this morning did not make my day. I see that MySQL is getting pushed to mysql-5.0.26-r1. I’m currently running with the 4 branch (mysql-4.1.21). Now the upgrade has some good associated to it. Stored procedures are supported in MySQL 5 which is great. I did a lot of… Continue reading Oh No.. MySQL upgrade (4.1 to 5.0)

Mozy is a FREE automatic remote backup program. You install the program on your machine, and you backup files to a remote server at their location. The signup took less than two minutes to complete and the application is very light and quick to download and install. After installing the program, log into the application… Continue reading Mozy.com Free Remote Backup.. it rocks!

Just recently, I assisted a good friend of mine with a harddrive failure. He had two drives in his machine hda and hdb. hda was his primary drive, and hdb was a file storage drive. Unfortunately, hda was dying, so we needed to swap it out. This can be tricky, so after completing this, I… Continue reading Replace primary drive how-to

Due to the Eolas/Microsoft patent problem, object tags (including Flash objects) will show a grey border around it, with a message to click to ‘activate’ this. This is a super annoying problem and has been addressed in multiple ways. I wanted to discuss one of the options/methods that works well for me. First here is… Continue reading How-to embed Flash using SWFObject.js

Today there was a need to be able to view my linux desktop (Gentoo + fluxbox) remotely. I also wanted to connect to the existing X session, and not create a new X session. I looked at vnc and tightvnc, but documentation was stating that either would be able to connect to an existing session.… Continue reading Use x11vnc to connect to existing X session

This how-to is for installing and configuring OpenVPN on a Gentoo server acting as a firewall/router. I’ll also discuss configuring a OpenVPN client on Windows XP. Here is a brief description of what OpenVPN is from their site: OpenVPN is a full-featured SSL VPN solution which can accomodate a wide range of configurations, including remote… Continue reading OpenVPN how-to including OpenVPNGui client for Windows XP

I just came across Technorati, a pretty great place for viewing Blogs, etc. I thought I’d give it a shot and submit Uno-Code! You can see my profile here: Technorati Profile

For the longest time I’ve been using LIKE and ‘%’ wildcard operators for doing my searching. This works great looking up one column in a database table. In a recent project I was needing the ability to search on multiple columns, as well as multiple tables. To do this efficiently, I decided to tryt he… Continue reading Full Text Searching in MySQL

I’ve run into this multiple times, and I always have to look it up so I’m going to write about it. If you have a recordset returned and you’ve looped through it once and need to loop through it again, you can use the mysql_data_seek() function. This will reset the pointer and it will be… Continue reading How to reset the cursor in MySQL recordset with PHP.

This site was going to originally be about Linux and PHP programming, but I thought I’d through this ASP/MSAccess problem in the mixer since it might benefit someone. I haven’t worked with Microsoft Access databases since my early days with ColdFusion. Just recently I had to work on a traditional ASP site using a MSAccess… Continue reading Microsoft Access and “ORDER BY clause conflicts with DISTINCT” problem