Browsing Category

MySQL

113 posts

Articles related to MySQL, Percona Server, MariaDB

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

MySQL Function to Convert Date To Words

Kedar
September 16, 2010

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…

View Post

How to generate Insert Statement in MySQL

Kedar
May 5, 2010

A lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tool which can extract insert statements for us readily. Some of the…

View Post

Steps to Move Copy Rename MySQL Database

Kedar
May 4, 2010

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…

View Post

MySQL Load Data Infile Syntax Generator Tool Download

Kedar
April 8, 2010

MySQL LOAD DATA INFILE is a common command used to load delimited data to MySQL database. Here’s a tool to generate the Syntax for MySQL’s LOAD DATA INFILE command. I…

View Post