Backup and Migrate | drupal.org

Backup and Migrate simplifies the task of backing up and restoring your Drupal database or migrating data from one Drupal site to another. It supports gzip, bzip and zip compression as well as automatic scheduled backups.

With Backup and Migrate you can dump some or all of your database tables to a file download or save to a file on the server, and to restore from an uploaded or previously saved database dump. You can chose which tables and what data to backup and cache data is excluded by default.

Security Notice backup files saved to the server are protected from the public by default by a .htaccess rule which will only work on correctly configured apache servers. If you are using a server other than apache, it is recommended that you do not save backups to the server or that you find another way to protect the backup directory from the public.

The module will attempt to check if the destination directory is publicly readable before writing to it, but users are strongly encouraged to confirm this manually by trying to directly download the backup files with a web browser.