get date in bash script...

Hi,

I have a bash script I run on cron.daily which dumps mysql to file, tars & gzips it, then runs a perl script to email the file to me. This works fine, but the problem is, I have loads of files with the same name, so have rename each daily backup if I want to save them in a backup folder. Is there a way of getting the script to not just name the file, but to append the date on to it as well? The current script is:

#!/bin/sh
/home/local/mysql/bin/mysqldump -uroot -password --opt my_db > /sqldata/my_db.sql
cd /sqldata/
tar -zcvf db_daily.tgz *.sql
cd /myscripts/
perl emailsql.cgi

Try this:

#!/bin/sh
/home/local/mysql/bin/mysqldump -uroot -password --opt my_db > /sqldata/my_db.sql
cd /sqldata/
filename="db_daily_"`eval date +%Y%m%d`".tgz"
tar -zcvf $filename *.sql
cd /myscripts/
perl emailsql.cgi

Thanks! That does the job perfectly

All,

Can you show this with full date:timestamp?

Would it be:



Thanks!

OMR

There is a manual page on pretty much every command in bash. just type "man {command}". for example: "man date". You can also just google for "man date" and see the unix manual page: http://unixhelp.ed.ac.uk/CGI/man-cgi?date. There is one small problem though, I think the colon ( is not allowed in filenames.