Misc
Read More
MySQL search and replace
This is a simple SQL query to perform search and replace in a MySQL table update tablename set fieldname = replace(fieldname,’search_for_this’,’replace_with_this’);
Category: Web
Linux
Read More
mysql on a nondefault socket
It is sometimes necessary to run two instances of mysql, like in my case. I need a mysql database in addition to the one Zimbra uses. One solution to this problem is to run the mysql database on a non default socket. This can be done by changing the following line in my.cnf my.cnf [client] […]
Web
Read More
Using vlogger to split Apache logs
Vlogger is a program that handles large amounts of virtualhost logs and splits it to separate files. This is a short HOWTO to configure it using Apache. Install vlogger in debian etch # aptitude install vlogger Make sure you have working Apache server Configuring vlogger Change the LogFormat line (there are multiple LogFormat lines – […]
Scripting
Read More
Rename files by wildcard pattern and correct the EXIF timestamp metadata
This is a little script I’ve written to correct all my image files since the EXIF timestamp information is one hour out of sync. The filenames have been renamed to comply to the EXIF information and has to be renamed again because of the one hour scew. The filename can look something like this 20080102-1201_DSC_0910.JPG […]