Hi
What is the best way to go about this and automating it. It there perhaps an app?
http://webgnuru.com/linux/rsync_incremental.php
easiest way to backup database is automysqlbackup
another article is here: http://www.liquidweb.com/kb/how-to-back-up-mysql-databases-from-the-command-line/
you can add that to your backup script.