How to dump only specific tables from MySQL?

Question

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

Possible duplicate of How to take backup of a single table in a MySQL database? — codeforester
– codeforester, Commented Oct 26, 2018 at 23:56

Lauri Lehtinen · Accepted Answer · 2010-06-07 05:58:38Z

253

Usage: mysqldump [OPTIONS] database [tables]

i.e.

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

answered Jun 7, 2010 at 5:58

Lauri Lehtinen

10.9k2 gold badges34 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Geeky Ninja · Accepted Answer · 2016-09-15 08:20:29Z

13

If you're in local machine then use this command

/usr/local/mysql/bin/mysqldump -h127.0.0.1 --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;

For remote machine, use below one

/usr/local/mysql/bin/mysqldump -h [remoteip] --port = 3306 -u [username] -p [password] --databases [db_name] --tables [tablename] > /to/path/tablename.sql;

edited Sep 15, 2016 at 8:20

Geeky Ninja

6,0468 gold badges44 silver badges55 bronze badges

answered Sep 15, 2016 at 7:02

Raja Bose

3442 silver badges9 bronze badges

1 Comment

Musa Haidari Over a year ago

Great! just if you add --where="CONDITION='VALUE'" would be great

Collectives™ on Stack Overflow

How to dump only specific tables from MySQL?

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related