MySQL Backup: Table By Table Backup With Auto Rotation, For Easy Restoration Of Partial/Full Database
Here is a MySQL backup script which can take table by table backups (individual backup files of each table of each database) in a compressed format. It also provides an automatic rotation of old backup files. The backup script handles innodb and myisam tables separately.