Using Node to export MySQL query results to a file as JSON

node-mysql2json.js

// https://github.com/felixge/node-mysql
// npm install mysql
var mysql = require('mysql');

// http://nodejs.org/docs/v0.6.5/api/fs.html#fs.writeFile
var fs = require('fs');

var client = mysql.createClient({
   user: 'root',
   password: 'mysqlpassword' 
});

client.query('select * from db.table;', function(err, results, fields) {
    if(err) throw err;

    fs.writeFile('table.json', JSON.stringify(results), function (err) {
      if (err) throw err;
      console.log('Saved!');
    });

    client.end();   
});