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