streaming.js

const spawn = require('child_process').spawn; // child_process spawn function
const app = require('express')(); // new express http server

app.use('/', (req, res) => {
  const ls = spawn('ls', ['-lh', '/usr']); // here would be the mysqldump command
  ls.stdout.pipe(res);
}); // piping the stdout (the output from the mysqldump command, in this case the ls command) to the response object 


// using fs
const fs = require('fs');

app.use('/old/bump', (req, res) => {
  const fileStream = fs.createReadStream('path_to_dump.sql');
  fileStream.pipe(res);
})