mysql-helper
_ _ _
| | | | | |
_ __ ___ _ _ ___ __ _| |______| |__ ___| |_ __ ___ _ __
| '_ ` _ \| | | / __|/ _` | |______| '_ \ / _ \ | '_ \ / _ \ '__|
| | | | | | |_| \__ \ (_| | | | | | | __/ | |_) | __/ |
|_| |_| |_|\__, |___/\__, |_| |_| |_|\___|_| .__/ \___|_|
__/ | | | | |
|___/ |_| |_|
Provides a helper to sync, clone, and backup local & remote databases.
| This package has been developed by H&H | Digital, an Australian botique developer. Visit us at hnh.digital. |
Requirements
- PHP 7.1.3 (min)
- zip
- pv
- mysql
- php-ssh2
Installation
Via commmand line:
bash <(curl -s https://hnhdigital-os.github.io/mysql-helper/builds/install)
Download the latest build:
curl -o ./mysql-helper -LSs https://github.com/hnhdigital-os/mysql-helper/raw/master/builds/mysql-helper
chmod a+x ./mysql-helper
Move it local bin:
mv ./mysql-helper /usr/local/bin/mysql-helper
Run the install command to run automatically dependency installation. NOTE: This currently only works on Debian (uses apt-get). See the software requirements to manually install.
mysql-helper install
Run the configure command to setup a profile, and add local and remote connections.
mysql-helper configure
Updating
This tool provides a self-update mechanism. Simply run the self-update command.
mysql-helper self-update
How to use
USAGE: mysql-helper <command> [options] [arguments]
backup Backup a specific local database
clone Clone database from one to another
configure Configure profiles and connections
display List databases available to this connection
install Install system requirements
restore Restore a specific local database
Contributing
Please see CONTRIBUTING for details.
Credits
License
The MIT License (MIT). Please see License File for more information.