title: SSH DB backup with dynamic filename with date
body: <p>Hello I am trying to backup a DB using an SSH/cron, everything works fine except I want to use a current date stamp within the command line so my backup file has a different name every time. </p>
  
  <p>Does any one know how to include the date at the moment it is taking the text literally?</p>
  
  <pre><code>myDATE=date +%Y-%m-%d; 
  
  mysqldump mydbname | gzip &gt; /home/mywebsite/vps_backups/my_db_back_${myDATE}.sql.gz;
  </code></pre>