This Tool allows Laravel/Lumen Developers to syncing mysql databases to the local environment from any configured environment like staging or production systems.
- mysqldump
- openssh
- mysql-client
composer require --dev n3xt0r/laravel-mysql-syncAdd your new provider to the providers array of config/app.php
'providers' => [
// ...
\N3XT0R\MySqlSync\Providers\MySqlSyncServiceProvider::class,
// ...
],publish the config
php artisan vendor:publish --provider="N3XT0R\MySqlSync\Providers\MySqlSyncServiceProvider"Add the config from the vendor directory to your config dir manually. Dont forget to register it inside of the bootstrap/app.php.
<?php
return [
/*
|--------------------------------------------------------------------------
| Remote Server Connections
|--------------------------------------------------------------------------
|
| These are the servers that will be accessible via the SSH task runner
| facilities of Laravel. This feature radically simplifies executing
| tasks on your servers, such as deploying out these applications.
|
*/
'connections' => [
'production' => [
'host' => 'example.com',
'username' => 'myUser',
'password' => '',
'key' => storage_path('id_rsa'),
'keytext' => '',
'keyphrase' => '',
'agent' => '',
'timeout' => 10,
],
],
/*
|--------------------------------------------------------------------------
| Remote Server Databases
|--------------------------------------------------------------------------
|
| These are the databases that will be accessible for syncing.
|
*/
'databases' => [
'laravel' => [
'connection' => 'production',
'host' => 'mysql.example.com',
'database' => 'myApp',
'user' => 'root',
'password' => 'myPassword',
],
'secondOptionalDb' => [
'connection' => 'production',
'host' => 'mysql.example.com',
'database' => 'customerDb',
'user' => 'root',
'password' => 'myPassword',
],
],
'environments' => [
'production' => [
/**
* be careful, this is the same order like on importing databases
* when you have constraints between database, set them to correct order.
*/
'databases' => [
'laravel',
'secondOptionalDb',
],
],
],
/**
* originally it should be the storage dir
* but you could configure any other directory, too.
*/
'storage' => storage_path(),
];php artisan db:sync --stage=production