# 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_table1, my_table_2, and 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.