Copy a record within the same table MySQL
Just a simple copy record function. First of all, pick a random temporary table name, and ensure you don’t have…
How to install MySQL Server on Centos
To install MySQL on Centos is a little different from Ubuntu – as I found out. Obviously APT is replaced…
Logging MySQL Queries
I often set up mysql query logging when I am diagnosing a problem. In the my.cnf file, enter (or update…
Installing a Microsoft MSI file in Wine
Wine doesn’t always play well with MSI files, so I have to install them through the terminal: wine msiexec /i…
Create changelog for SVN
Its fairly very simple to get a changelog from Subversion when you know the revision numbers you are searching for:…
Using MAX and DATE_FORMAT to get the latest date from a MySQL table
Don’t use DATE_FORMAT when trying to assertain the latest date in a table. It won’t work. DATE_FORMAT will convert the…
Cancelling the event for jQuery imgAreaSelect
http://odyniec.net/projects/imgareaselect/ I have been using this excellent jQuery plugin which allows the user to draw a lasso around several objects…
Setting up a Google Apps account on Empathy
I found that no matter what I tried, I could not get Google Talk to work through Empathy (on my…
How to install PEAR (Linux)
PEAR (PHP Extension and Application Repository) is a bunch of extensions you can install on your server to uitilise clever…
Editing massive files on Windows
I you need to edit a MySQL dump which is 2.5Gb and you are unfortunately running Windows, I’ve found a…