notes 1 - 3 of 3:
2006-12-18
Incremental MySQL backup
mysqldump --extended-insert=false
then using diff -u, diff -u0, or maybe diff -e, between original mysqldump image and the new one to get the incremental.
2005-09-19
MySQL and files backup script
mysqldump -q -A -hlocalhost -uuser -ppassword > SQL_`date +%F`.sql
zip -q -m SQL_`date +%F`.zip SQL_`date +%F`.sql
find www/ | zip Files_`date +%F`.zip -q -@
mv SQL_`date +%F`.zip www/mysql_dump/
mv Files_`date +%F`.zip www/mysql_dump/