MySQL 8 Cookbook

Specific databases and tables

To back up only a specific database, execute this:

shell> mysqldump --databases employees > employees_backup.sql

To back up only a specific table, execute this:

shell> mysqldump --databases employees --tables employees > employees_backup.sql