O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required