title: Export MySQL table rows as individual files (specifically JSON) in one go
body: <p>I have over 750 JSON files I need to create from a MySQL Database table. </p>
  
  <p>It is the WordPress "wp_options" table, but this is a MySQL question. </p>
  
  <p>The wp_options table has the following properties. </p>
  
  <pre><code>option_id, option_name, option_value, autoload
  </code></pre>
  
  <p>The "<strong>option_name</strong>" is to become the JSON file name. </p>
  
  <p>I am fine if I "have to" rename each file name manually. </p>
  
  <p>The "<strong>option_value</strong>" is to become the JSON data. </p>
  
  <p>Is there a way I can do this more efficiently instead of creating an empty JSON file for each row and then copying the data base option_value to the JSON file? </p>
  
  <p>My main concern is with 750 files to make I am a little weary I will miss something or double up on something, and this information has to be exact. </p>
  
  <p>NOTE: I've read this stack article (which is the closest I could find) @ <a href="http://goo.gl/RnV5cf" rel="nofollow">http://goo.gl/RnV5cf</a>. But, It doesn't seem to be working as expected given the Wordpress wp_options values I think. </p>