# 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.