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’);
Linux
Read More
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 […]
Linux
Read More
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 :)
Linux
Read More
Howto copy a DVD-9 (dual-layer) movie in linux (fast)
More and more people are getting dual-layer DVD-burners and don’t want to compromise quality by shrinking the movie down to DVD-5 (singel-layer) copies. This howto will show you how to make a 1:1 (unshrinked and unencrypted) ISO-image of an encrypted DVD-9 movie in linux using the commandline. Prerequisites (these are likeley available in your distros […]
Scripting
Read More
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’ {} \;