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

DIFFERENCE BETWEEN ORACLE AND MySQL -05

DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More

DIFFERENCE BETWEEN ORACLE AND MySQL -04

DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More

DIFFERENCE BETWEEN ORACLE AND MySQL -01

DIFFERENCE BETWEEN ORACLE AND MySQL. The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). Both the Oracle Database and MySQL are database management systems currently produced and managed by the Oracle Corporation. The Oracle… 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