prasinos.eu

Restoring a database to an earlier version using a dump is easy: drop the database, recreate it and load the dump. But what happens if you don’t have the necessary rights on the database server for droping and creating databases? In that case you have to drop the tables one by one before loading the dump. How can we do this efficiently?

I am a happy owner of a Macbook (“Santa Rosa”) on which I promptly installed linux (Debian). The Macbook came with a nice infrared remote control which is easily set up in linux with the help of the great LIRC project.
I will not go into the general setup here as it is covered in the LIRC documentation, but instead I will describe how a button on the remote can be bound to more “exotic” functions like displaying the remaining time when using mplayer.

About 2 weeks ago the applets I had in my gnome-panel starting acting up: they would not stay in place after login/logout even if with the option “Lock To Panel” checked.

Recently, while I was writing a bash script to process some tab delimited data, I found a neat way of setting control characters (such as tab) as field delimiters in tools like cut or sort.

For some months now, my wife’s laptop was making a strange high pitch whining noise. The noise was not that loud but noticeable and it was the kind that gives you a headache after a while.

As I am the system administrator of the family, my wife asked me to investigate :-)