If your hosting is providing you shell access, Drush (Drupal Shell) is a blessing if you want to make some repetitive actions faster, easier and more robust. The installation bit might be a little scary for new users (especially if it is the first time you hear the terms shell, bash, etc.) but it is definitely worth the effort.

With drush, among many many other things (e.g. install, update, enable/disable contributed modules), you can also:

backup (mysql dump) your database

    $ drush sql dump --result-file=backup.sql

reload/copy (mysql load) your database (some_database)

    $ drush sql connect #connect to MySQL via Drush
    $ mysql some_database < backup.sql #load file into database

Source: Nathan Rambeck

Author: (16)