Drop all tables from a MySQL DB without dropping the database itself

Mar 6, 11:13 AM by Grigorios Prasinos

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?

read more

,

Comments

---

Mplayer + LIRC: Show elapsed time at the press of a button!

Nov 30, 08:10 PM by Grigorios Prasinos

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.

read more

,

Comments

---

Fix for applets not staying in place in gnome panel

Oct 7, 06:54 AM by Grigorios Prasinos

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.

read more

,

Comments

---

Bash scripting - field separator trick

Sep 20, 04:04 PM by Grigorios Prasinos

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.

read more

,

Comments

---

Solved - whining noises on Sony Laptop

Sep 8, 09:01 AM by Grigorios Prasinos

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 :-)

read more

,

Comments

---

« Older