MySQL 8 Cookbook

Faster reload

You will notice that in the output, the secondary indexes are omitted from the CREATE TABLE statement. This will speed up the restoration process. The indexes are added at the end of the INSERT using the ALTER TABLE statement.

Indexes will be covered in Chapter 13, Performance Tuning.

Previously, it was possible to dump all tables in the mysql system database. As of MySQL 8, mysqldump and mysqlpump dump only non-data dictionary tables in that database.