Migrating tables

There are different ways to migrate huge amount of data (tables) in MySQL. The most common approach everyone follows is to create a new table with the same structure as the old one and then insert the records using a select on the old table. Eg:

create table new_tbl_name like old_db_name.tbl_name;
insert into new_tbl_name select * from old_db_name.tbl_name;

But a little googling helped me to find a very good alternative to this.

alter table old_db_name.tbl_name rename new_db_name.tbl_name;

It’s a very good method compared to all others. It doesn’t create a temporary table but just moves the data definition file and the data file to the new DB location. It works well for MyISAM and InnoDB

Documentation

What is Documentation? As webster would put it in relavance to the IT industry it would be the usually printed instructions, comments, and information for using a particular piece or system of computer software or hardware. Literally there are many types of documentation pertaining to the purpose. As you climb up the ladder you would be doing more of that and less of technical job.
So what is the use of such documentation? In the beginning I was not too much inclined to document all the activities. But now I feel that it is actually a very good practise. The preparation is like always a very tedious/lame process. You would have dug more than what you require for the document. Still it helps in a way if you want to do it again without any glinches and also quicker.

My point and shoot camera

Finally got my hands on the latest point and shoot camera into my collection. It is the Canon Powershot SD500. Deciding on the camera was a very tough choice. My main criteria for the search were that it should be small and very easy to use. After going through lot of review sites like dpreview, I zoomed in on this one. Got my hands on it last week though. So now there is going to be more pics on flickr.