title: Proper format for a mysqldump dynamic filename in a cron?
body: <p>I have a crontab set up that errors out every time I attempt to do it. It works fine in the shell. It's the format I'm using when I attempt to automatically insert the date into the filename of the database backup. Does anyone know the syntax I need to use to get cron to let me insert the date into the filename?</p>
  
  <pre><code>mysqldump -hServer -uUser -pPassword Table | gzip &gt; 
  /home/directory/backups/table.$(date +"%Y-%m-%d").gz
  </code></pre>
  
  <p>Thanks in advance!</p>