process.env.NODE_CONFIG_DIR="../config/";
var mysql = require("promise-mysql");
var config = require("config");
var fs = require("fs");

var connection;

mysql.createConnection({
      host: config.get("database.host"),
      user: config.get("database.username"),
      password: config.get("database.password"),
      multipleStatements: true
    }).then(function(conn) {
      connection = conn;
      return connection.query("CREATE DATABASE IF NOT EXISTS " + config.get("database.name"));
    }).then(() => {
      return connection.query("USE " + config.get("database.name"));
    }).then(() => {
      var exampleDB = fs.readFileSync("exampleDatabase.sql", "utf8");
      return connection.query(exampleDB);
    }).then((res) => {
      console.log("Finished importing sql. Your install is now ready.");
      process.exit(0);
    }).catch((err) => {
        console.log("ERROR", err);
        process.exit(1);
    });

process.env.NODE_CONFIG_DIR="../config/";
var mysql = require("promise-mysql");
var config = require("config");
var fs = require("fs");

var connection;

mysql.createConnection({
      host: config.get("database.host"),
      user: config.get("database.username"),
      password: config.get("database.password"),
      multipleStatements: true
    }).then((conn) => {
        connection = conn;
        return connection.query("DROP DATABASE " + config.get("database.name"));
    }).then(function() {
      return connection.query("CREATE DATABASE IF NOT EXISTS " + config.get("database.name"));
    }).then(() => {
      return connection.query("USE " + config.get("database.name"));
    }).then(() => {
      var exampleDB = fs.readFileSync("exampleDatabase.sql", "utf8");
      return connection.query(exampleDB);
    }).then((res) => {
      console.log("Finished importing sql. Your install is now ready.");
      process.exit(0);
    }).catch((err) => {
        console.log("ERROR", err);
        process.exit(1);
    });

Install now drops and recreates the database
Install now drops and recreates the database
