dcblogdev / laravel-db-sync
Sync database down.
Fund package maintenance!
dcblogdev
Requires (Dev)
- orchestra/testbench: ^5.0|^6.23|^7.0
- pestphp/pest: ^1.21
- pestphp/pest-plugin-laravel: ^1.1
README
Introduction
Sync remote database to a local database
Connection can be made over SSH or using a remote MySQL connection.
Install
Install the package.
composer require dcblogdev/laravel-db-sync
Config
You can publish the config file with:
php artisan vendor:publish --provider="Dcblogdev\DbSync\DbSyncServiceProvider" --tag="config"
.env
Set the remote database credentials in your .env file
When using SSH Add:
REMOTE_USE_SSH=true
REMOTE_SSH_PORT=22
REMOTE_SSH_USERNAME=
REMOTE_DATABASE_HOST=
REMOTE_DATABASE_USERNAME=
REMOTE_DATABASE_NAME=
REMOTE_DATABASE_PASSWORD=
REMOTE_DATABASE_IGNORE_TABLES=''
REMOTE_REMOVE_FILE_AFTER_IMPORT=true
REMOTE_IMPORT_FILE=true
For only MySQL remote connections:
REMOTE_DATABASE_HOST=
REMOTE_DATABASE_USERNAME=
REMOTE_DATABASE_NAME=
REMOTE_DATABASE_PASSWORD=
REMOTE_DATABASE_IGNORE_TABLES=''
REMOTE_REMOVE_FILE_AFTER_IMPORT=true
REMOTE_IMPORT_FILE=true
Set a comma seperate list of tables NOT to export in REMOTE_DATABASE_IGNORE_TABLES
Usage
To export a remote database to OVERRIDE your local database by running:
php artisan db:production-sync