title: chef file cache not where expected
body: <p>While trying the following example on chef leaning:</p>
  
  <p><a href="https://learn.chef.io/manage-a-web-app/ubuntu/configure-the-database/" rel="nofollow noreferrer">https://learn.chef.io/manage-a-web-app/ubuntu/configure-the-database/</a></p>
  
  <p>I ran in to an issue with this piece of code</p>
  
  <pre><code># Create a path to the SQL file in the Chef cache.
  create_tables_script_path = File.join(Chef::Config[:file_cache_path], 'create-tables.sql')
  </code></pre>
  
  <p>The file is not showing up in the location specified:</p>
  
  <pre><code>STDOUT:
         STDERR: sh: /tmp/create-tables.sql: No such file or directory
         ---- End output of mysql -h 127.0.0.1 -u db_admin -pdatabase_password -D my_company &lt; /tmp/create-tables.sql ----
  </code></pre>
  
  <p>The file does show up in:</p>
  
  <pre><code>/tmp/kitchen/cache
  </code></pre>
  
  <p>Any ideas on what to tweak?</p>