This is a collection of articles regarding the MySQL utility mysqldump that were previously published on this blog. This is for quick reference.
Tag: mysqldump commands
MySQL – Dump All Database At Once
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 Only INSERT Statements
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 – Dump only specific rows
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
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
Big Data and SQL 