duplicate a table in mysql

create table tmp select * from test.bugs;
insert into tmp select * from test.bugs;

KNOPPIX

This is a bootable linux system. When windows can't be booted, this system can be used to obtain the data on the hard drive.

I learnt something today

Text is different between Windows and Linux. To convert a window text file, use:
cat log.log | tr -d '\r' > new.log

I also learnt easy_install, which is a python module (easy_install) bundled with setuptools that lets you automatically download, build, install, and manage Python packages. To install an unziped file, use -Z, an upgraded file use -U. For example, to install a newer version of MySQLdb, type:
sudo easy_install -UZ MySQLdb-python

Change display colors in a terminal

http://www.linux-sxs.org/housekeeping/lscolors.html

LAMP on Ubuntu

http://www.supriyadisw.net/2006/12/lamp-installation-on-ubuntu
http://www.debianadmin.com/apache2-web-server-with-php-support-in-ubuntu.html

datetime module in Python

http://pleac.sourceforge.net/pleac_python/datesandtimes.html