Ryan Chapin's Website

The following is an example of how to run a query on the command line to output the result of a MySQL query to a CSV file.

Create a text file with the your query, query.sql:

SELECT * FROM hosts;

The run the following command:

mysql –skip-column-names -uuser -ppassword database < query.sql | sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;’ > filename.csv

This will run the MySQL query and output the results to a text file in .csv format.

The sed commands do the following:→ Continue reading “Retuning a MySQL Query in CSV”

Let’s say that you have deleted a file (or directory) in your checked out copy of a svn repository and then checked it in (committed your change).

You discover that you really would like to have that file back in your current version of your repo. You can either us the svn merge command, or copy the file from a previous version of your repo.

Here is how you can copy the file from a previous version:

svn rm blah.txt→ Continue reading “Retrieving a Previously Deleted File in Subversion”

Should you find yourself running a Linux box behind a proxy that requires authentication you will need to update your setup so that you can get access to the outside world, and make some configuration changes to yum.

First, add the following to your /etc/yum.conf (note, this is incredibly insecure as you will now have your proxy uid and password in clear text on your machine. You should remove your login details after you have made your connections):

proxy=http://proxy_url:80
proxy_username=uid→ Continue reading “Setting up Proxy Authentication for a Linux Box to use yum”

http://www.droid-life.com/2010/02/23/quick-fix-issues-mounting-your-motorola-droid-in-windows-xp-2/→ Continue reading “Mount Your Motorola Droid Under WinXP”

http://ant.apache.org/manual/tutorial-HelloWorldWithAnt.html→ Continue reading “An Excellent Beginners Tutorial for Apache Ant”

A collegue pointed me to ThoughtPolice.co.uk:? a website with an entire library of VMWare images of various Linux distros.

Want
to play around with some different distros of Linux, here’s a great way
to try out a wide selection really quickly (as long as you have a lot
of bandwidth).→ Continue reading “A Library of Pre-Configured, Linux, VMWare Guests”

My parent’s Win XP box became infected with Desktop Security 2010 and I was tasked with it’s removal and cleanup.

Following are the steps that I took, some of which required some additional digging and experimentation that was not in the top 10 or so search results.

The first hurdle was to actually get access to the Windows Desktop.

In this case when the machine booted to Windows the Desktop Security 2010 program would essentially take over the machine. I → Continue reading “How To Remove Desktop Security 2010”

The following is a how to on getting putty set up putty on a Win XP box to enable you use an RSA (or DSA) private/public key pair to connect to a linux server over SSH.

• Generate your keys on the linux server to which you want to connect.

• SSH to your server
• go to your home directory .ssh/
• Enter the following command to generate the key pair:

• # ssh-keygen -t rsa
• Enter a passphrase for your keys

This will → Continue reading “Setting Up SSH Keys to Connect from Windows to a Linux Server with Putty”

When you want to search for the dot (.) character in a regular expression and not use it as a metacharacter use the following syntax:

String regexPattern = “[.]”;→ Continue reading “Searcing for a dot "." character with a Java Regular Expression”

With Java 5.0 enums became much more powerful, click here for an overview.

I am working on a project that is using an enum to keep track of an attribute of one of my objects and wanted to initialize a HashMap inline in the call to the enum’s constructor. Such was my delight to find out that using a simple initializer block that it was a snap.

Here is the relevant snippet of code that illustrates the syntax:

public → Continue reading “Java In-line Initialization of a Map in the Constructor of an Enum Constant”