how to write a shell script to backup mysql data into a file and gunzip it? how to use the date to be the name of the zipped backup file?
#!/bin/bash
mysqldump -u username -ppassword dbname >dump_file_name
today=date +%Y%m%d%H%i ## this is backquote! tar -cvf $today.tar dump_file_name gzip $today.tar
date +%Y%m%d%H%i
