# How to mysqldump specific tables
mysqldump includes all the tables of the database by default. In order to dump only a specific set of tables using
mysqldump, you need to specify the database name followed by the name of the tables you want to include in the dump.
mysqldump my_database my_table1 my_table2 my_table3 > my_backup.sql
After running the command from the example above, the output file
my_backup.sql will contain only the schema and data of the tables
my_table3 because those are the only tables specified in the command. All other tables that are not mentioned will not be included in the dump.
If you want to include a single table, mention only the name of that table in the command. Here you can find an example about how to mysqldump a single table.