Acme Sprockets

Though there is no single command to drop all of the tables in a MySQL database, it is pretty easy to do with a simple script.

I was recently asked about backing up a MySQL database for a remotely hosted Drupal site. Assuming you have SSH access to the hosting account, this is trivial to do from a Linux machine.