Pario TechnoBlob

A chronological documentation test project, nothing serious, really!

Author: Hans-Henry Jakobsen

Curious IT geek and dad.
Misc

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’);

Read More
Network

Network upgrade Ubuntu Server 8.04 to 8.10

This post describes how I upgraded my Ubuntu (Hardy Heron) 8.04 server installation to (Intrepid Ibex) 8.10 from the command line. First you’ll need to make sure you are running the latest packages # sudo aptitude update # sudo aptitude safe-upgrade Then you will need to install the Ubuntu upgrade package # sudo aptitude install […]

Read More
Linux

Rename file name suffix to uppercase or lowercase

This is a little oneliner to rename a files suffix from/to uppercase/lowercase. Rename a jpg suffix to JPG in the current folder # find -name “*.jpg” | while read a; do mv “$a” “${a%%.jpg}.JPG” ; done The work JPG can be replaced by any other word :)

Read More
Linux

Rename files in a folder to lower-case using perl

This is a simple oneliner to rename files to lower-case using perl # perl -e ‘rename($_, lc) || warn “$_: $!\n” for @ARGV’ * You can also do this recusively using find and perl # find . -type f -exec perl -e ‘rename($_, lc) || warn “$_: $!\n” for @ARGV’ {} \;

Read More