Frank Ralf, Projektmanager und Site Builder

Backup

Drupal tables - to backup or not to backup?

When backing up or migrating a Drupal site with Backup & Migrate you have to backup the whole structure of your database but not necessarily the content of all tables.

You can set the the Default Database Backup Options at admin/config/system/backup_migrate/profile/list/edit to exclude data from certain tables from the backup. But how do you decide which data to exclude? A great blog post by Adelle Frank lists the Drupal tables to (probably) not backup:

  • any table with 'cache' in the name
  • any table that starts with 'search' in its name
  • any table with 0 (no) records in it
  • advanced_help_index
  • authmap
  • batch
  • flood
  • history
  • node_comment_statistics
  • queue
  • semaphore
  • sequences
  • sessions
  • tracker_node & tracker_user
  • watchdog

You should read the whole article for more information why this data (probably) is dispensable: http://adellefrank.com/blog/drupal-database-tables-files-backup-migrate

And hopefully these Backup & Migrate profile settings will be exportable via Features in the future so you don't have to do these settings manually for all of your installations.

This comment will automatically be synchronized on social networks.
All comments are moderated.

More articles

Cathy Theys 05/12/2013 - 08:28
Cathy Theys 05/10/2013 - 10:46
John Heaven 04/25/2013 - 17:02

Partners