How to dump only specific tables from MySQL?

3 years ago
Posted by andri
Board Tutorial
1,124 views


If my database has 10 tables and I want to dump only 3 tables, is it possible with mysqldump command?

Solution :

 Usage: mysqldump [OPTIONS] database [tables] 

i.e.

 mysqldump -u username -p db_name table1_name table2_name table3_name >  dump.sql 

Source :   stackoverflow.com