hnhdigital-os/mysql-helper

Provides a helper to sync, clone, and backup local & remote databases.

0.1.21 2019-07-26 02:41 UTC

Requires

• php: ^7.1.3
• hnhdigital-os/php-cli-helper: ^1.0
• illuminate/database: 5.8.*
• laravel-zero/framework: 5.8.*
• nunomaduro/laravel-console-menu: ^2.1
• padraic/phar-updater: ^1.0.6
• symfony/process: ^4.2
• symfony/yaml: ^4.2
• vlucas/phpdotenv: ^3.4
• zendframework/zend-text: ^2.7

Requires (Dev)

• mockery/mockery: ^1.0
• phpmd/phpmd: ~2.0
• phpunit/phpunit: ^8.2
• squizlabs/php_codesniffer: ~3.0

MIT

• Rocco Howard

• cli
• mysql
• console
• backup
• clone

README

                           _        _          _
                          | |      | |        | |
 _ __ ___  _   _ ___  __ _| |______| |__   ___| |_ __   ___ _ __
| '_ ` _ \| | | / __|/ _` | |______| '_ \ / _ \ | '_ \ / _ \ '__|
| | | | | | |_| \__ \ (_| | |      | | | |  __/ | |_) |  __/ |
|_| |_| |_|\__, |___/\__, |_|      |_| |_|\___|_| .__/ \___|_|
            __/ |       | |                     | |
           |___/        |_|                     |_|

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

• Rocco Howard
• All Contributors

License

The MIT License (MIT). Please see License File for more information.