-
Daily Popular
- Load Delimited Data (csv, excel) into MySQL Server
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Ash Wednesday:Repent, and believe the Gospel and MySQL
- MySQL Stored procedure – Split Delimited string into Rows
- JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java
- Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | free download mp3
- MySQL Stored procedure to Generate-Extract Insert Statement
- Working with EditPlus Text Editor-Regular Expression How To
- No More Spool Space Teradata Query Solution
- The Dos Chat – Lan Messenger
-
MySQL Archive
-
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
Posted on January 30, 2012 | No CommentsMore...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 | 7 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 | 6 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... -
MySQL Load Data Infile Syntax Generator Tool Download
Posted on April 8, 2010 | No CommentsMore...The 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... -
MySQL related file types and basic information
Posted on March 29, 2010 | 5 CommentsMore...This post covers the basic information of files that MySQL Server uses / creates for various tasks. my.cnf : It is the main configuration file for MySQL. You may find...