MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

9.4 Using mysqldump for Backups


Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave Service compatibility checks and modifications. Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave Service DB System using the MySQL Shell load dump utilities. Installation instructions for MySQL Shell can be found here.

This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways:

mysqldump produces two types of output, depending on whether the --tab option is given: