Blog

A MySQL Sub Select Wish

After doing a lot of searching and reading I think I came up empty on a subselect I wanted to do in MySQL. Here’s what I was trying to do: tabel1 id rec 1 record 1 2 record 2 table2 … Read More

How to Check MySQL Version on Command Line

You can check for your version of MySQL on the command line with the following: # mysql –version or # mysql -V I tried to search checking mysql version on the command line a couple times without success, so it’s … Read More

Finding Files Edited Today on Linux

Find all files in this directory (.) modified in the last day (-mtime -1) that aren’t directories (\! -type d) and execute the list function on them ls -l: find . -mtime -1 \! -type d -exec ls -l {} … Read More

Chmod Recursively

To chmod recursively, meaning directories and all directories within, you’d use the -R option: chmod -R 755 From the chmod man page: -R, –recursive change files and directories recursively This is all simple enough, but for some reason I always … Read More

Working with MySQL SET Data Type

I’m getting started on a new project which is built around a table using MySQL SET data types in a number of columns. There’s some parts of this, which will most likely present a number of challenges. The table was … Read More

Removing Multiple .svn Directories

At one time, I had a tarred site still containing all its .svn directories. Needing to just start over and remove all .svn directories, I found the answer at Linux by Examples under the aptly named page “Remove All .svn … Read More

Search with Find, Xargs, and Grep

I’ve watched people search for character matches on Unix and Linux machines at times with not a lot of success. A very good way to make this search on a Unix/Linux box is to use the find, xargs, and grep … Read More

IP Cloud

There’s a concept I’ve been thinking of lately, which I see no reason won’t be taking off within a few years. It’s a concept of an “IP Cloud”. Technically, it’s a centralized database of ip-associated user profiles compiled by all … Read More

Import pMachine Blog Posts Into TypePad

Ok, here’s a little bonus. I spent some time importing blog posts from pMachine into TypePad the other day. To import the posts into TypePad you can use the Movable type import format. This format is discussed here: http://www.sixapart.com/movabletype/docs/mtimport The … Read More

Webalizer with Virtual Hosts on Fedora Core 5

Quick notes on my implementation of Webalizer on multiple virtual hosts with Fedora Core 5. There is documentation that I used off the mrunix webalizer faq files. Mainly the INSTALL file. Here are the steps I followed: create ‘webalizer’ directory … Read More