Attached is a simple script to backup Drupal databases in an incremental-archive-friendly way (1.7KB). Instead of dumping the database into one big SQL file, this script creates many small files; one per table. With a blacklist option to exclude certain tables. It stores the structure (CREATE TABLE statements) in a separate file too. Separate files are usefull in an incremental backup situation: Drupal has many tables who’s content hardly ever changes, and has tables whos content is completely rewritten every X days.. Read more..