Found this great script for automatically backing up local mysql databases to local backup storage.  Details can be found in this post

The scripts itself lives here:

http://sourceforge.net/projects/automysqlbackup/files/

Tags: automatic backup, backup, database, mysql, sql