/mysqlcompare

a command line tool to compare two mysql databases and store the changes to an sql file

Primary LanguagePHPMIT LicenseMIT

Downloads

mysqlcompare

mysqlcompare is a command line tool to compare two database schema's and retreive the difference in an sql file.

Installation

composer global require lloadout/mysqlcompare

Usage

Init

Connection data can be defined in a connections.json file , to create the connection file you run the following command

mysqlcompare init

a connections.json file will be created , specifying a source and target connection and an sqlfile to store the sql statements in. If you connect through an ssh connection you specify user@host:port in the ssh field of the json. Your password will be prompted, either for you user or your ssh key.

Compare

The execution of comparison is done via

mysqlcompare compare