bash custom variable

[dthscyth]

I have a bash script that backups database. What I want to do is save the file with its name and the current date. Here is my script.

#!bash/sh
#
MYDATETIME=;date +%Y-%m-%d

mysqldump -uroot -pdthscyth jobs > jobs_$MYDATETIME.sql


The problem is when saving the file the value of the variable is not saved. Instead of jobs_2010-12-29.sql the filename is jobs_.sql. Please help. Thanks and Happy New Year!.

[dthscyth]

I figure it out. Commands like date should be inside a back quote (`) so instead of

mysqldump jobs > jobs_$MYDATETIME.sql

it should be...

mysqldump jobs > jobs_`date +%Y-%m-%d.sql`