It is possible to dump a specific table and specific rows from a table using mysqldump. This article explains how to do that. The mysqldump
Category: MySQL
MySQL – Single Transaction or Skip Lock Tables
When using mysqldump to backup databases, many people are unsure whether to use the –skip-lock-tables or –single-transaction options to prevent locking the tables. This article
MySQL Status through mysqldump
You can easily run the following line at command prompt to retrieve the MySQL server uptime statistics along with the number of connected threads, the
CREATE PROCEDURE IF NOT EXISTS in MySQL
During various migrations/deployments, it is required to check to see if the stored routine (stored procedure or user-defined function) already exists before creating it. Because
MySQL Database Cloning
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
mysqldump – ignore a single or multiple tables
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
Big Data & SQL 