# How to mysqldump a single table

In order to dump a single table using mysqldump, you need to specify the database name followed by the name of the table.

After running the command from the example below, the output file my_backup.sql will contain only the schema & data of the table my_table.

mysqldump my_database my_table > my_backup.sql

If you want to include more than one table, all you have to do is to mention the names of the extra tables you want included. Here you can find an example about how to mysqldump specific tables.