shipit-db
v1.8.5
Published
Database syncing tasks for Shipit.
Downloads
15
Readme
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: '[email protected]',
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