Mysql-dumpall

Script to dump all database tables as individual .sql files. Can be set up as a cron for continuous dumps.

Script

#!/bin/bash
for d in $(mysql -e 'show databases;' | grep -v Database);
        do for t in $(mysql $d -e 'show tables;' | grep -v Tables);
                do mysqldump $d $t > /home/mysqldump/$d.$t.sql;
        done;
done

Usage

Save on server and either run manually or set up cron job.

will need to create /home/mysqldump directory (or change the directory name).