node-MySQL-import

DESCRIPTION

Makes it very easy to import .sql files of any size without a hassle.

HOW IT WORKS

Unlike some other libraries that have been seen out there in the wild, this module does not parse .sql files in to chunks of seperate queries, instead it uses the binaries already availiable on the machine.

SUPPORTED OS PLATFORMS

• windows (gets the binary location directly from MySQL)
• linux (uses 'mysql' command)
• mac (uses 'mysql' command)

HOW TO INSTALL

npm i node-mysql-import

EXAMPLE USAGE

const MySQLImporter = require('node-mysql-import');
 
// setup
var test = new MySQLImporter('localhost', 3306, 'root', 'password', 'database', 'test.sql');
 
test.init()
    .then(test.dropDatabaseIfExists)
    .then(test.createDatabaseIfDoesNotExist)
    .then(test.execute)
    .then(function(success){
        console.log('success');
        console.dir(success);
    })
    .catch(error => {
        console.log('error');
        console.dir(error);
    })

HOW TO USE WITH ASAR PACKED APP

Since asar packed app-directories are not natively approachable by the OS, we recommend copying the .sql file to the appdata directory and pass that location to the constructor