jezzis/mysqlsyncer

This package provides a easy way to synchronize database structure to laravel

MYSQL-SYNCER (Laravel 5 Package)

, _(*1)

This tool provide an easy way to synchronize database structure including tables, views, functions, procedures for Laravel 5., _(*2)

Installation

1) In order to install mysql-syncer, just add, _(*3)

  "jezzis/mysqlsyncer":"dev-master"

to your composer.json. Then run composer install or composer update., _(*4)

2) In your config/app.php add, _(*5)

    Jezzis\MysqlSyncer\MysqlSyncerServiceProvider::class

Configuration

If you want to customize the base path of the sql file, please copy src/config.php to laravel project config directory, rename it to msyncer.php, _(*6)

return [

    'sql_path' => './', // sql file base path where MySQL-Syncer is looking for.

    'driver' => 'mysql', // connection driver, currently only supports MySQL.
];

Usage

run the command in console:, _(*7)

    # php artisan db:sync --drop <file>

Params

• file: The file path of the sql file, without .sql extension

Options

• --drop: allow drop columns, keys

Troubleshooting

Grant select privilege on mysql.func and mysql.proc to make sure the tools can fetch the definition of functions & procedure., _(*8)

License

mysql-syncer is free software distributed under the terms of the MIT license., _(*9)

Contribution guidelines

Support follows PSR-1 and PSR-4 PHP coding standards, and semantic versioning., _(*10)

Please report any issue you find in the issues page. Pull requests are welcome., _(*11)