mysqlcompare is a command line tool to compare two database schema's and retreive the difference in an sql file.
composer global require lloadout/mysqlcompare
Connection data can be defined in a connections.json file , to create the connection file you run the following command
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
[email protected]:port in the ssh field of the json. Your password will be prompted, either for you user or your ssh key.
The execution of comparison is done via