eserozvataf / sqlsync
Installs: 8
Dependents: 0
Suggesters: 0
Security: 0
Stars: 4
Watchers: 1
Forks: 0
Open Issues: 0
Type:project
Requires
- php: >=5.6.0
- dg/mysql-dump: ~1.3.0
- monolog/monolog: ~1.13.1
- scabbiafw/scabbia2-config: *
- scabbiafw/scabbia2-formatters: *
- scabbiafw/scabbia2-lightstack: *
- scabbiafw/scabbia2-services: *
- scabbiafw/scabbia2-tasks: *
Requires (Dev)
This package is auto-updated.
Last update: 2023-09-08 19:54:47 UTC
README
SqlSync is planned to be an open source database syncronous tool. However it is in early stages of development, and supports database dump transfer only for now.
Installation
Please make sure that you can access php command line tool via php
command. Further commands will be executed on Terminal or Command Prompt:
Step 1: Download and install composer dependency manager.
php -r "readfile('https://getcomposer.org/installer');" | php
Step 2: Create a new sqlsync project via composer.
php composer.phar create-project eserozvataf/sqlsync:dev-master
Step 3:
Rename config.sample.php
to config.php
and edit configuration.
Running
Transfer Command: Transfer command simply creates or overwrites a new database/schema on client, by reading the source database from the server. The workflow of this procedure is preparing a sql dump file on server side, downloading it to client, execution of the dump on the client.
vendor/bin/scabbia sqlSync:transfer my_database
Replace my_database
with your database name which will be copied to your client.
Requirements
- PHP 5.6.0+ (http://www.php.net/)
- Composer Dependency Manager (http://getcomposer.org/)
Links
Contributing
It is publicly open for any contribution. Bugfixes, new features and extra modules are welcome. All contributions should be filed on the eserozvataf/sqlsync repository.