Principal Software Engineer/Architect, motorcyclist, drummer, and artist
Sometimes you will accidentally create a file that has special characters in the file name which then prevents you from running commands on it. In that case, you can resort to accessing the file via it’s inode number.
To do so:
$ ls -il | more
In the directory in which the file that you want to examine resides
This will output a list of files, the first column being the inode number.
You can then run the following command → Continue reading “Deleting a File Using the Inode Number”
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”
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.
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”