So how do you take backup of your MySQL database? Simple, launch SQLYog or HeidiSQL and export your database. Well its an easy solution on Windows. How would you go about it on Linux or simply put how wud you do it on command prompt. The answer is mysqldump. Its there on your system once […]Read more "MySQL – Dump those tables"
As we were getting bored with the routine life, we decided to go somewhere. And that somewhere turned out to be Munnar. We reached the place @ about 6.30 in the morning. I must say that the place is SERENE. Its the place to be. The place was covered with mist and the entire hilly […]Read more "Munnar – the place to be!!!!"
Database is nothing but collection of tables. Tables are useless unless we perform some operations on them. Operations on such tables require time to process. Sometimes these operations are pretty fast, sometimes not. In case of databases these operations get executed when we run some query. So depending on what and how much of information […]Read more "MySQL – Indexing"