Load columnar text file into MySQL table
Kedar
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…
Browsing Category
MySQL-Articles
79 posts
MySQL related blog posts
MySQL – Alter table-change datatype of column with foreign key
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…
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
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 Sensitivity
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…
MySQL Load Data Infile with Stored Procedure
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…
10 Steps: MySQL Monitoring through Nagios: Install & Configure
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…