title: Using date to append filename to database backups made by cron
body: <p>I want to maintain multiple dated backups via cron but I can't seem to figure out how to concatenate the file name in cron.</p>
  
  <p>Currently I just use the following:</p>
  
  <pre><code>/bin/mv /var/www/vhosts/mysite.org/dbBackups/today.sql /var/www/vhosts/mysite.org/dbBackups/yesterday.sql
  
  /usr/bin/mysqldump --add-drop-table -u dbname -pmypass dbname &gt; /var/www/vhosts/mysite.org/dbBackups/today.sql
  </code></pre>
  
  <p>What I tried was no good: </p>
  
  <pre><code>/usr/bin/mysqldump/mysqldump --add-drop-table -u dbname -pmypass dbname &gt; '/var/www/vhosts/mysite.org/dbBackups/' . date +%Y%m%d . dbname.sql
  </code></pre>
  
  <p>So how do I concantenate that string in cron?</p>