db-cli

Database CLI tool for Creating, Copying, and Syncing databases quickly. It can create local databases, copy local or remote database or copy remote to local databases. It cannot write to remote databases. It uses Project Config Files to store the settings for each project. Prject Config files and Backups will be stored in ~/.dbcli

* Currently only supports mysql and mariadb
* All Databases are collated as utf8mb4_unicode_ci

Installation

npm i --global @ggedde/db-cli

Test that the CLI is working and see what Version it is

db -v

See Help

db -h

* If it does not work then you might need to add the global path to your $PATH

db copy [-o] [project_config_file]

    Copies Remote Database to Local Database using the project_config_file.
    Local Database will be backup before getting overwritten

    -o   Omits the backup files. Use only if you are sure you will not need to revert back.

db backup [-l | -r] [project_config_file]

    Backsup databases from both local and remote

    -l   Backup local database Only
    -r   Backup remote database Only

db add [project_config_file]

    Adds a new project_config_file, but does not create a local database

db create [-a] [project_config_file]

    Creates a new database on your localhost

    -a   Also add a new project_config_file

db list

    List all Project Config Files in the Databases Folder

db backups

    List all Backup Files in the Backups Folder