A node.js script to backup a MySQL database using MySQLDump. Can be added to a node-cron timer to automate backups.

mysql_backup.js

var fs = require('fs');
var spawn = require('child_process').spawn;
var wstream = fs.createWriteStream('dumpfilename.sql'); //Name of SQL dump file

var mysqldump = spawn('mysqldump', [
    '-u',
    'DB_USER',
    '-p DB_PASSWORD',
    'DB_NAME'
]);

mysqldump
    .stdout
    .pipe(wstream)
    .on('finish', function () {
        console.log('Completed')
    })
    .on('error', function (err) {
        console.log(err)
    });