i have this script and it works but the output isn't zipped so it's huge. I want to save it zipped but i don't understand shell script and i don't want to mess it up. Can you help me zip it like so: ".sql.zip", please?
/usr/bin/mysqldump -h $mysql_host -u $mysql_username -p$mysql_password $mysql_database > $backup_path/$today/$mysql_database-`date +%H%M`.sql
Any help appreciated.