Save Space When Backing-Up Drupal Database
Here's a quick one. mysqldump is useful for backing up your Drupal website database (also look at mysqlhotcopy for MyISAM only databases). If you use the Drupal search system on your site then you probably have a massive search index. This index often takes up just as much space as the rest of the site, and can always be rebuilt so doesn't need to be backed up. mysqldump includes an option to exclude tables. For example:
Easy Drupal Backup with Rsync and MySQLDump
Here's a nice easy way of running backups for your Drupal sites. To successfully backup a Drupal website you need to:
- backup all the files, themes, modules, etc, and,
- backup the database content
I'll not go into the reasons why backups are essential part of support for Drupal, or any websites, because if you've ever had a server crash and die on you then you will understand. If you haven't then I suggest it's only a matter of time, and you start a rigorous backup routine now.
Read on for one backup method that produces nice incremental backups of your Drupal site without taking up too much diskspace, and dumps SQL content of your Drupal database at the same time.
