How to Backup a Drupal Site

Backing up a Drupal site has always been a tedious process. I've just learned about an easier way.

The Old Way

In the past I've always used this method to backup a Drupal site:

  1. Backup the website with SSH
  2. Figure out how to login to client's webhosting control panel and either mysqldump over SSH or use PHPmyAdmin.

The Easier Way

(I learned about this method from Ferenc's travel photographer blog. His Photography Directory is built in Drupal.)

Download and install Drupal's Backup and Migrate Module. Then go to admin > content > Backup & Migrate and follow the directions.

Basically, you can just click a button and backup your entire Drupal database with only the data you want to keep. The unnecessary data from the cache and accesslog tables aren't backed up so the file size of the backups is smaller than it would be if doing a mysqldump.

Here's a screenshot:

drupal-backup-and-migrate.png

There are also options to compress the file before download, or add a datestamp:

drupal-backup-settings.png

The Backup & Migrate modules is one of the best Drupal Modules. I can't imagine going back to the old method. It's great because even clients can backup their own websites. This module doesn't backup the files for you, but it's quick to backup the files over SSH, or just download over sFTP.

Average: 4.1 (11 votes)

Comments

the exclude list

Thanks for this.

Could please make a full list of possible tables we could exclude while migrating?
Or perhaps there isn't much left other than those listed in the above screenshot?

Webmaster Tips's picture

tables to exclude in Drupal backup

I just use the default tables and it works well. I've been using this module on a few sites and it's great.

I can't