title: MySQL select into outfile /tmp no output
body: <p>I cannot get the following code to generate any output. The MySQL user has "all" grant level, /tmp is writable, the query returns a results set. </p>
  
  <pre><code>mysql&gt; SELECT field FROM test_table WHERE condition='test'
      -&gt; INTO OUTFILE '/tmp/test.csv'
      -&gt; FIELDS TERMINATED BY ','
      -&gt; ENCLOSED BY '"'
      -&gt; LINES TERMINATED BY '\n';
  Query OK, 1 row affected (0.00 sec)
  
  mysql&gt;
  [1]+  Stopped                 mysql
  [root@web1 ~]# cat /tmp/test.csv
  cat: /tmp/test.csv: No such file or directory
  </code></pre>
  
  <p>Should I be seeing different output from MySQL in case of failure? </p>
  
  <p>Can I verify the result further than "1 row affected"?</p>