Browsing Category

MySQL-Articles

78 posts

MySQL related blog posts

MySQL – Alter table-change datatype of column with foreign key

Kedar
April 23, 2012

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 tables…

View Post

Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY

Kedar
January 30, 2012

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…

View Post

Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitivity

Kedar
December 6, 2010

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. MySQL Case Sensitivity and…

View Post

MySQL Load Data Infile with Stored Procedure

Kedar
November 30, 2010

Did you ever need to run LOAD DATA INFILE in a procedure? May be to automate or dynamically perform the large data file load to the MySQL database. In this…

View Post

10 Steps: MySQL Monitoring through Nagios: Install & Configure

Kedar
November 18, 2010

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…

View Post

Installing MySQL On Mac OS X (Darwin Kernel)

Kedar
October 28, 2010

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…

View Post