Recommend this page to a friend! |
Classes of Shabeer ALi M | mSync PHP Sync MySQL Databases | README.md | Download |
|
DownloadmSyncmSync - a MySQL schema synchronization utility DescriptionmSync will create a schema file as JSON so that you can easily migrate schema to your production or any other work envirment easily. Currently mSync will support only table & views. Why we use mSyncDevelopers find very hard to synchronize mysql schema. The current conventional method is to export to sql & update it in production. The main demerit of this method is all the old values of the production will be loose & the process is bit hectic. In Order to solve this we developed a platform where you can update the schema in a file and by running msync it will update only those changes without losing any old structure or data. PrerequisitesTo run mSync you need PHP. ConfigurationFirst you need to update the database configuration in mSync config file (config.php). In confi.php you can add multiple hosts with a host name. Usage (CLI)Create: Creating schema (schema.json) file from localhost. Make sure that localhost configuration is updated in config.php
Creating schema (schema.json) file from some other host (Ex: yourdomain.com).
Update : Once the schema is created you can update/sync with other host or database by using update command.
Updating remote mysql
Note : If you are executing this query from localhost please make sure that your IP is accessible to update your production host. |