|Ratings||Unique User Downloads||Download Rankings|
|Not yet rated by the users||Total: 149||All time: 9,021 This week: 189|
|msync 1.0.0||Custom (specified...||5||PHP 5, Databases, Systems administration|
This class can update the MySQL database schema between servers.
mSync - a MySQL schema synchronization utility
mSync 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.
Developers 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.
To run mSync you need PHP.
First 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.
Create: Creating schema (schema.json) file from localhost. Make sure that localhost configuration is updated in config.php
php msyc.php create
Creating schema (schema.json) file from some other host (Ex: yourdomain.com).
php msyc.php create yourdomain.com
Update : Once the schema is created you can update/sync with other host or database by using update command.
//by the following query the schema.json will be update with your localhost php msyc.php update
Updating remote mysql
php msyc.php update yourdomain.com
Note : If you are executing this query from localhost please make sure that your IP is accessible to update your production host.
|Version Control||Unique User Downloads||Download Rankings|