#!bin/bash

mysqldump -u root -p'password**' db_name | gzip -v > /path/to/folder/file_name_`date +\%Y-\%m-\%d_\%H-\%M-\%S`.sql.gz