Drush database commands

Update: See http://data.agaric.com/use-drush-sync-database-from-one-site-another

[Note: currently written mostly from memory after using the commands, not copy-pasting proven commands as i usually do]

Using Drush to dump databases from production to development, we can easily use some flags provided by drush sql to exclude the data from tables we don't need, namely by declaring them structure tables. To name a whole set of tables schema (structure) only, we can pass in a key:

--structure-tables-key

We can get more information on everything to do with any Drush command with the drush help command, such as for the sql-dump command:

drush help sql-dump

A default key provided is "common".

drush sql-dump --structure-tables-key

Personally, i usually want to keep the watchdog table, so may need to define an agaric profile for this.