title: secure-file-priv preventing INTO OUTFILE command
body: <p>I'm using:</p>
  
  <p><code>SELECT * FROM accounts INTO OUTFILE("C:/Users/Home/Documents/test.txt")</code> </p>
  
  <p>but I get the error:</p>
  
  <pre><code>(db:1290) The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
  </code></pre>
  
  <p>I don't have permission to change the security settings of the database but was wondering if there was some alternative command that would work around this problem. Thank you</p>