MySQL 8 Administrator???s Guide

Performance and scalability

It should not to be considered as a fast or scalable solution for backing up large amounts of data. The backup takes some time and restoring data can be very slow, as SQL statements involve index creation, disk I/O for insertion, and so on. It can retrieve and dump table data row by row; otherwise it can take a whole table and buffer it in the memory for dumping it.

The following is the execution syntax for mysqldump:

shell> mysqldump [options] db_name [tbl_name ...] shell> mysqldump [options] --databases db_name ...shell> mysqldump [options] --all-databases

There are more than 25 options available for modifying the operation of the mysqldump command and they can be retrieved by using the mysqldump --help command. ...