BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY (Article -18).

BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY. Please Refer the previous article. BACKUP AND RECOVERY IN MySQL (Article -17). Using mysqldump utility we can take the backup of only data(ignoring structure ) Check the databases list.

To take the backup of only data… Read More

Table Maintenance in MySQL (Article -16)

Table Maintenance  in MySQL. This page contains several commands you will use to optimize, analyse and repair tables. It also presents the mysqlcheck command line tool. Table maintenance will separated in five ways .They are  : Check Table Repair Table Analyse Table Optimise Table mysqlcheck  … Read More

MySQL Clients (Articles -10).

MySQL Clients   Learning Objectives : List the available clients for administrative tasks and their basic  purposes. Invoke mysql clients and common command line options. Invoke and us the MySQL command line client MySQL. Use the mysqladmin for administrative clients APIs (Drivers and Connectors).  … Read More

LOG FILES IN MySQL

LOG FILES IN MySQL. Before going to look on logfiles we need to know what is the use of my.cnf file. By default my.cnf file will be in /etc/my.cnf location, when ever you try to restart MySQL server look for my.cnf in /etc/ location.

Read More