Dumping all tables with drush
Submitted by clemens on Thu, 2010/05/20 - 12:46pm
I want a clean database without clicking.
echo "\
SELECT concat('drop table ', table_name, ';') \
FROM information_schema.tables \
WHERE table_schema=schema()" \
| `drush sql-connect` \
| grep "^drop table " \
| `drush sql-connect`
This work only for single drupal / single schema installs.