bjoernsteinborn/shipit-db

shipit-db

A set of database tasks for Shipit.

Features:

• Works via shipit-cli and grunt-shipit
• Optionally ignore specified tables

Roadmap

• DB Backup tasks

Install

npm install shipit-db

Usage

Example shipitfile.js

module.exports = function (shipit) {
  require('shipit-db')(shipit);

  shipit.initConfig({
    default: {
      db: {
        ignoreTables: ['some_table'],
        local: {
          host     : 'localhost',
          adapter  : 'mysql',
          username : 'root',
          password : 'root',
          socket   : '/Applications/MAMP/tmp/mysql/mysql.sock',
          database : 'mysite_local',
        },
      }
    },
    staging: {
      servers: 'user@myserver.com',
      db: {
        remote: {
          host     : '127.0.0.1',
          adapter  : 'mysql',
          username : 'myusername',
          password : '123password',
          database : 'mysite_staging',
        }
      }
    }
  });
};

Dump your local database, upload and import to remote:

shipit staging db:push

Dump your remote database, download and import to local:

shipit staging db:pull

Options (shipit.config.db)

db.ignoreTables

Type: Array

An array of database tables to ignore.

db.local \ db.remote

Type: Object

An object of database credentials.

License

MIT