vancoding / copybase

Copy or backup databases quickly 🚀

About

Copybase is a database tool that helps you quickly copy a database. Simply define your databases config in a .copybaserc.yaml, and start copying or backuping them with a simple command line:

copybase copy staging local

copybase backup prod

Note: copybase uses the native tools to build command lines to launch. So you still need to install mysql, psql or mongo.

Getting Started

Installation

# install copybase globally
npm i -g copybase
# with yarn:
yarn global add copybase

# or locally
npm i copybase
# with yarn:
yarn add copybase

You also need to install the official db tools:

• Instructions for MongoDB
• Instructions for MySQL
• Instructions for PostgreSQL

Configuration

Copybase uses cosmiconfig, so you just need to create a file .copybaserc.yaml (or .copybaserc.json, .copybaserc.js) with the following sample config:

backup:
  # output folder when you run the backup command
  folder: .backup
# list all databases you want to work with
databases:
  # sample config for localhost
  local:
    database: demo
    protocol: postgresql
    hostname: 127.0.0.1
    port: 54321
    username: demo
    password: password

  # sample config for a remote database, uring uri
  staging:
    uri: postgresql://demo:staging.example.com@localhost:54322/demo

Note: you can pass some extra parameters to the command line underneath. Look at .copybaserc.yaml in the current repository.

Usage

Usage: copybase [options] [command]

Copy quickly a database

Options:
-V, --version output the version number
-h, --help display help for command

Commands:
copy [options]          <fromDatabase> <toDatabase> Copy a database
list:tables [options]   <database> List all tables in database
backup [options]        <database> Backup a database
help [command]          display help for command