The last time i post on how you can convert mysql files to csv, but how about if you want to directly convert the entire sql table to excel file, well here is a trick.

mysql -uroot -p your_db -Be “select * from your_table” > /home/folder/your_table.xls

Hope this helps… Do drop me a comment if it did.

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

Linux 2.6.26 kernel update released by ZDNet’s Paula Rooney — Linus Torvalds quietly released another update to the Linux kernel over the weekend that offers better support for kernel-based virtual machines, a kernel debugger, improved webcam support and new support for the One Laptop Per Child architecture. Version 2.6.26 was released on Sunday, July 13. What’s most interesting is the inclusion of a kernel debugger, Linux contributor [...]

In this how-to by Falko Timme, he will show you on how you can properly setup and enable Compiz Fusion on an Ubuntu 8.04 LTS (Hardy Heron) desktop. and he uses NVIDIA GeForce FX 5200 in this step by step tutorial.

Enabling Compiz Fusion On An Ubuntu 8.04 LTS Desktop (NVIDIA GeForce FX 5200)

Here’s a list of the most common Compiz Fusion keyboard shortcuts.

SUPER+SHIFT+DRAG LEFT MOUSE = draw fire
SUPER+SHIFT+C = clear fire
CTRL+ALT+DRAG LEFT MOUSE = rotate cube
CTRL+ALT+LEFT ARROW = rotate cube
CTRL+ALT+DOWN ARROW = flat desktop
SHIFT+ALT+UP = initiate window picker
CTRL+ALT+DOWN = unfold cube
ALT+TAB = window switch
SUPER+TAB = flip switcher or ring switcher, depending on which is enabled.
ALT+F7 = initiate ‘move windows’
SHIFT+F9 = water effect
SHIFT+F10 = slow animations
CTRL+ALT+D = show desktop

For Grouping and Tabbing:
SUPER+S = select single window
SUPER+T = tab group
SUPER+Left = change left tab
SUPER+Right = change right tab
SUPER+G = group windows
SUPER+U = ungroup windows
SUPER+R = remove group window
SUPER+C = close group
SUPER+X = ignore group
Hold the SUPER button then select the windows you want to group and then hit SUPER+G.

The SUPER key is the Windows key on most keyboards.