- Load Delimited Data (csv, excel) into MySQL Server
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- MySQL Stored procedure – Split Delimited string into Rows
- No More Spool Space Teradata Query Solution
- Working with EditPlus Text Editor-Regular Expression How To
- Selected Oscar Wilde Quotes
- Collection for insulting – one liners
- The Dos Chat – Lan Messenger
- How to echo colored text in linux shell script
- Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | download mp3
Posted on January 10, 2013 | No Commentsinnodb_flush_method variable specifies how InnoDB opens and flushes log and data files. In Innodb optimization, setting the variable innodb_flush_method tweaks the performance most of the times but there are cases...
Posted on December 17, 2012 | No CommentsEverybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you...
Posted on September 13, 2012 | 2 CommentsThis mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have...
Posted on July 5, 2012 | 6 CommentsAt times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but...
Posted on May 3, 2012 | No CommentsEver come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table...
Posted on April 23, 2012 | No CommentsSchema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved. Below is a short example for altering...
Posted on January 30, 2012 | 1 CommentMySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs...
Posted on December 6, 2010 | No CommentsDo you ever need to transfer databases between servers? Different OSes? Two common ways of data migration: 1. Create mysqldump and load it. 2. File transfer using SCP. Case Sensitivity...
Posted on November 30, 2010 | 20 CommentsOkay! So here we will use Load Data syntax to load file into MySQL Server in a Stored procedure. Yep! It’s a workaround. Download MySQL UDF: [root@localhost kedar]# wget http://www.mysqludf.org/lib_mysqludf_sys/lib_mysqludf_sys_0.0.3.tar.gz...
Posted on November 18, 2010 | 17 CommentsNagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL...
Posted on October 28, 2010 | 1 CommentRecently I happen to install MySQL on Mac OS X (Darvin Kernel). Below are the quick 5 steps to accomplish the task. Step 1: Check Mac Version Very first step...
Posted on September 16, 2010 | 3 CommentsRecently I saw a MySQL Stored Function requirement on Experts-Exchange for converting date into some specific words format. You may find MySQL function for date to words conversion online; even...
Posted on May 5, 2010 | 8 CommentsA lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tools which can extract insert statements for us readily. of the time...
Posted on May 4, 2010 | No CommentsMoving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux...
Posted on April 8, 2010 | No CommentsThe LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. I...
- Agneepath Agneepath Agneepath 5 Comments
- Excel to MySQL 73 Comments
- Manual Mode 9 Comments
- QA No Comments
- men in black-3 movie review 4 Comments
- qtp 3 Comments
- Download JaxtrSMS 16 Comments
- QA-Testing 5 Comments
- QA-Testing No Comments
- Personal 6 Comments
- Personal No Comments
- Personal No Comments
- Personal 1 Comment
- Personal 2 Comments
- Just for fun No Comments
- Review No Comments
- Personal 7 Comments