title: Append current date to the filename via Cron?
body: <p>I've created a Cron task at my webhost to daily backup my database and I would like it to append the current date to the filename.</p>
  
  <p>My Cron job looks like this</p>
  
  <pre><code>mysqldump -u username -pPassword db_name &gt; www/db_backup/db_backup+date%d%m%y.sql
  </code></pre>
  
  <p>But the file I get is this: <strong>db_backup+date</strong> no file extension or date.</p>
  
  <p>I've also tried this command  </p>
  
  <pre><code>mysqldump -u username -pPassword db_name &gt; www/db_backup/db_backup_'date +%d%m%y'.sql 
  </code></pre>
  
  <p>but that doesn't even give an file output.</p>
  
  <p>What is the right syntax for getting the date appended to my file??</p>