db-sync icon indicating copy to clipboard operation
db-sync copied to clipboard

PHP library with command line tool for efficiently syncing tables between remote MySQL databases

Results 11 db-sync issues
Sort by recently updated
recently updated
newest added

Is there a complete example anywhere of how to use this on a PHP web page?

Hello Friends, When i try to sync to target, it says: Column not found: 1054 Unknown column '*fieldname*' in 'field list' How to first create the column and then sync...

Hello, I really want db-sync to work with my databases but I can't run the command. For some reason, the scrip is adding some strange characters into query and generating...

I have found an issue, that if I set a different column as the primary key, it says that the MySQL syntax is incorrect. [info] Hash calculation: CONCAT(COALESCE(LOWER(CONV(BIT_XOR(CAST(CONV(SUBSTR(MD5(CONCAT_WS('#', `username`, `groupname`,...

Hi! I have several huge tables with primitive versioning. Actual data are in the end of table, so I prefer to sync from end of table to beginning but there...

I keep getting this problem for tables with UNIQUE KEY: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '[email protected]' for key 'CUSTOMER_ENTITY_EMAIL_WEBSITE_ID' this table has "entity_id" as the primary key and...

My Table **has a primary key**, but when I run The DbSyn, it returns an error _**table does not have a primary key**_ what can I do. Thanks in advance

I'm using Laravel 5.6.*. It's in my `composer.json` as: `"laravel/framework": "~5.6.0"`. As a result, it requires `"symfony/console": "~4.0"` in my `composer.lock` file. When I try to install: `composer require joegreen0991/db-sync...

It seems that "php" and "php-mysql" must to be install before executing db-sync. I recommend that installation instruction is written on the README.