Sometimes we need to format our sql file to csv format, we usually dump mysql table to a file and then later on we need toview this file or check on the data but the problem is you still need to format it so that you can easily read it. So here is a small trick to directly conver your mysql dump file to csv.

mysql -uroot -p -e"select * from your_table" your_database > your_table.csv

That’s all folks… hope this trick helps you… drop a comment if it did.

PowerTOP is a Linux tool that finds the software component(s) that make your laptop use more power than necessary while it is idle. PowerTOP combines various sources of information from the kernel into one convenient screen so that you can see how well your system is doing, and which components are the biggest problem. With this tool you can find what software is using the most power on your system. Especially notebook users will benefit from reduced power consumption - there will be more time left on battery power.

Read the rest of this entry »

This is a small script from Phil Hughes to convert filenames in Linux to lowercase letters.


1 #!/bin/sh
2 # lowerit
3 # convert all file names in the current directory to lower case
4 # only operates on plain files--does not change the name of directories
5 # will ask for verification before overwriting an existing file
6 for x in `ls`
7 do
8 if [ ! -f $x ]; then
9 continue
10 fi
11 lc=`echo $x | tr ‘[A-Z]‘ ‘[a-z]‘`
12 if [ $lc != $x ]; then
13 mv -i $x $lc
14 fi
15 done

My Boss recently gave this to me as a present when he came here in the philippines Last July. Well what can i say this is one heck of a present. As a Linux System Admin i have access to lots of protected websites and servers so i keep it securely on this device. What is good about this device is it also runs on Linux provided you are using the newest Linux Kernel.

Read the rest of this entry »

Bruce Perens creator of the Open Source Definition and the founder of OSI (Open Source Initiative), sets his view on the surprising decision of Microsoft to support a major open source and one of the biggest competitor of their IIS server, The Apache Web Server. Microsoft joined the Apache Project as a platinum sponsor and pledge a $100,00 a year to support the project.

Does Microsoft already given up the fight? Or are they up for something?

Read Full Story ….