..

Combine this:

http://www.sitepoint.com/blogs/2004/04/30/backing-up-mysql/#

with that:

http://blogs.oracle.com/SanthoshK//2008/08/automate_linux_scp_command.html