MySQL Archive
-
Load columnar text file into MySQL table
Posted on May 3, 2012 | No CommentsMore...Ever 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... -
MySQL – Alter table-change datatype of column with foreign key
Posted on April 23, 2012 | No CommentsMore...Schema 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... -
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
Posted on January 30, 2012 | 1 CommentMore...MySQL 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... -
Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy
Posted on December 6, 2010 | No CommentsMore...Do 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... -
Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL
Posted on November 30, 2010 | 16 CommentsMore...Okay! 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... -
10 Steps: MySQL Monitoring through Nagios: Install & Configure
Posted on November 18, 2010 | 10 CommentsMore...Nagios 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... -
Installing MySQL On Mac OS X (Darwin Kernel)
Posted on October 28, 2010 | 1 CommentMore...Recently 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... -
MySQL Function to Convert Date To Words
Posted on September 16, 2010 | 3 CommentsMore...Recently 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... -
MySQL Stored procedure to Generate-Extract Insert Statement
Posted on May 5, 2010 | 8 CommentsMore...A 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... -
Steps to Move Copy Rename MySQL Database
Posted on May 4, 2010 | No CommentsMore...Moving, 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...