How to dump a single table from database using drush?

Question

I'm aware of mysqldump utility, but is there any way of dumping a single table from database using drush (e.g. for sql-dump, sql-sync)?

shrish · Accepted Answer · 2015-05-30 03:34:55Z

40

You can use --tables-list option on drush command to dump specific tables.

drush sql-dump --tables-list=node,system > exportdb.sql

Above command will only make sql-dump for node and system tables.

answered May 28, 2014 at 9:53

shrish

1,8393 gold badges19 silver badges29 bronze badges

2

First of all "--table-list" is unknown option. Actually "-tables-list" is used. Second thing that correct option "--tables-list" is not working on Windows machine and full DB dump will be created instead.
– Vasyl Zaytsev
Commented Jan 26, 2015 at 17:11
Tested drush sql-dump --tables-list=rules_config --ordered-dump on Drush 8.1-dev, it seems to work fine.
– kenorb
Commented Apr 4, 2016 at 16:38
Full DB dump will be created if the table in tables-list doesn't exitsts (may due misspeling or not adding prefix) - github.com/drush-ops/drush/issues/3708 .
– Eugene Bocharov
Commented Jan 23, 2021 at 9:07

Add a comment |

1 Answer 1