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 will not write to remote databases (for peace of mind). 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
* Requires mysql-client to be installed on your system
* All Databases are collated as utf8mb4_unicode_ci
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
Adds a new project_config_file, but does not create a local database
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.
Creates a new database on your localhost
-a Also add a new project_config_file
Backsup databases from both local and remote
-l Backup local database Only
-r Backup remote database Only
List all Backup Files in the Backups Folder
List all Project Config Files in the Databases Folder