Body: 

The backup and migrate module is an awesome module that you can use to create a MySQL dump file. You can use it to schedule database backups to the server filesystem, remote FTP server or even an amazon s3 bucket.

In this post I'll demonstrate how to setup a scheduled backup to a remote FTP server.

Like all Drupal contrib modules, just download the module and copy it into sites/all/modules and enable the module.