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
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
MySQL ERROR 1227 (42000) at line 18: Access denied
While dumping the database using mysqldump, sometimes we encounter the following warning message. Warning: A partial dump from a server that has GTIDs will by
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
Big Data and SQL 