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
Tag: mysqldump
mysqldump – extended insert
By default, –extended-insert, -e is enabled when using mysqldump to create backups of MySQL databases. As seen in the example below, the dump file is
MySQLDump Backup All Databases Into Separate Files
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 – Complete reference
This is a collection of articles regarding the MySQL utility mysqldump that were previously published on this blog. This is for quick reference.
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
Big Data & SQL 