[...] Behold the power of Drush (once you are ssh'd in and navigated to your drupal root directory)
drush cc
drush sql-dump > ~/my-sql-dump-file-name.sql
Those two commands clear all the Drupal caches and then dump the sql database to a file in your home directory. Awesome sauce!