node-mysqlpm

0.1.6 • Public • Published

MySQL Partition Manager

A Node.js library for streamlining the backup and restore of MySQL partitions.

Alpha

This library is in alpha. It works but it hasn't been tested extensively. Successful tests run on Mac OSX, Ubuntu/Debian using MySQL 5.6.x.

Installation

$ npm install node-mysqlpm --save

Usage

// core deps
var
    path = require('path');
 
// module deps
var
    MySQLPartitionManager = require('node-mysqlpm');
 
var
    options = {
        connection: {
            host: 'localhost',
            user: 'root'
        },
        backupDir: path.resolve(__dirname, './backup') // must be on the same machine that hosts MySQL instance,
        isDebug: true
    },
    pm = MySQLPartitionManager.forge(options);
 
pm.backup({
    schema: 'database_name',
    table: 'table_name',
    partition: 'partition_name'
}, function (error) {
    pm.end(); // release connection pool
    if (error) {
        throw error;
    }
});
 
pm.restore({
    schema: 'database_name',
    table: 'table_name',
    partition: 'partition_name'
}, function (error) {
    pm.end(); // release connection pool
    if (error) {
        throw error;
    }
});

Versions

Current Tags

  • Version
    Downloads (Last 7 Days)
    • Tag
  • 0.1.6
    20
    • latest

Version History

Package Sidebar

Install

npm i node-mysqlpm

Weekly Downloads

21

Version

0.1.6

License

MIT

Last publish

Collaborators

  • adigiovanni