mysql-tools

    0.1.2 • Public • Published

    mysql-tools

    Create mysql database dump and restore

    npm Travis node

    Features

    • Create dump sql file of database
    • Restore dump sql file to database

    Example

    var  MysqlTools= require('mysql-tools');
    
    
    // create database dump sql file
    var tool = new MysqlTools();
     tool.dumpDatabase({
        host: 'localhost'
        , user: 'root'
        , password: 'root'
        , dumpPath: 'home/backup'
        , database: 'test'
    }, function (error, output, message, dumpFileName) {
        if (error instanceof Error) {
           console.log(error);
        } else {
           console.log(output);
           console.log(message);
           console.log(dumpFileName);
        }
    });
    // restore dump sql file to database
    var tool = new MysqlTools();
     tool.restoreDatabase({
        host: 'localhost'
        , user: 'root'
        , password: 'root'
        , sqlFilePath: '/home/backup/test1430762417616.sql'
        , database: 'test'
    }, function (error, output, message) {
        if (error instanceof Error) {
           console.log(error);
        } else {
           console.log(output);
           console.log(message);
        }
    });
    

    Keywords

    none

    Install

    npm i mysql-tools

    DownloadsWeekly Downloads

    17

    Version

    0.1.2

    License

    none

    Last publish

    Collaborators

    • ee
    • navalp