Easy MySQL Database Backups
mysqldump --databases my_database --user admin --password --host db.ideaharbor.org | gzip > backup.`date +%Y-%m-%d`.sql.gz
There, that wasn’t so bad, now was it?
Full documentation: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html