Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants

Kedar
December 17, 2012

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

View Post

MySQL function returns dates of specified day & between date range

Kedar
September 13, 2012

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

View Post

19 comments

How To Generate Random test Data In MySQL

Kedar
July 5, 2012

Are you tired of manually generating test data for your MySQL tables? If you’re looking for random data generator, look no further! Introducing the MySQL Random Data Generator, a powerful…

View Post

Load columnar text file into MySQL table

Kedar
May 3, 2012

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…

View Post

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