I often need timestamp on the commandline or in scripts to save files with the exact time.
In the shell you can easy get a unix timestamp when you enter the following command:
You can now simple save a mysqldump from with the exact time in the filename.
mysqldump DATABSE > DATABASE-`date +%s`.sql
Also you are able to create a bash/zsh alias for the timestamp. Just put the follwing line in your shell configuration:
alias timestamp = date +%s
Good Night, Daniel