No description, website, or topics provided.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
lib
tasks
.jshintrc
README.md
index.js
package.json

README.md

shipit-db

A set of database tasks for Shipit.

Features:

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