Drupal tables - to backup or not to backup?
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
- tracker_node & tracker_user
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.