Laravel 5.6 and Symfony Console

[sonnysavage]

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 --dev

I get this error:

Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - Installation request for joegreen0991/db-sync ^3.3 -> satisfiable by joegreen0991/db-sync[v3.3.0].
    - Conclusion: remove symfony/console v4.0.6
    - Conclusion: don't install symfony/console v4.0.6
    - joegreen0991/db-sync v3.3.0 requires symfony/console ^3.2 -> satisfiable by symfony/console[v3.2.0, v3.2.1, v3.2.10, v3.2.11, v3.2.12, v3.2.13, v3.2.14, v3.2.2, v3.2.3, v3.2.4, v3.2.5, v3.2.6, v3.2.7, v3.2.8, v3.2.9, v3.3.0, v3.3.1, v3.3.10, v3.3.11, v3.3.12, v3.3.13, v3.3.14, v3.3.15, v3.3.16, v3.3.2, v3.3.3, v3.3.4, v3.3.5, v3.3.6, v3.3.7, v3.3.8, v3.3.9, v3.4.0, v3.4.1, v3.4.2, v3.4.3, v3.4.4, v3.4.5, v3.4.6].
    - Can only install one of: symfony/console[v3.2.0, v4.0.6].
    - Can only install one of: symfony/console[v3.2.1, v4.0.6].
    - Can only install one of: symfony/console[v3.2.10, v4.0.6].
    - Can only install one of: symfony/console[v3.2.11, v4.0.6].
    - Can only install one of: symfony/console[v3.2.12, v4.0.6].
    - Can only install one of: symfony/console[v3.2.13, v4.0.6].
    - Can only install one of: symfony/console[v3.2.14, v4.0.6].
    - Can only install one of: symfony/console[v3.2.2, v4.0.6].
    - Can only install one of: symfony/console[v3.2.3, v4.0.6].
    - Can only install one of: symfony/console[v3.2.4, v4.0.6].
    - Can only install one of: symfony/console[v3.2.5, v4.0.6].
    - Can only install one of: symfony/console[v3.2.6, v4.0.6].
    - Can only install one of: symfony/console[v3.2.7, v4.0.6].
    - Can only install one of: symfony/console[v3.2.8, v4.0.6].
    - Can only install one of: symfony/console[v3.2.9, v4.0.6].
    - Can only install one of: symfony/console[v3.3.0, v4.0.6].
    - Can only install one of: symfony/console[v3.3.1, v4.0.6].
    - Can only install one of: symfony/console[v3.3.10, v4.0.6].
    - Can only install one of: symfony/console[v3.3.11, v4.0.6].
    - Can only install one of: symfony/console[v3.3.12, v4.0.6].
    - Can only install one of: symfony/console[v3.3.13, v4.0.6].
    - Can only install one of: symfony/console[v3.3.14, v4.0.6].
    - Can only install one of: symfony/console[v3.3.15, v4.0.6].
    - Can only install one of: symfony/console[v3.3.16, v4.0.6].
    - Can only install one of: symfony/console[v3.3.2, v4.0.6].
    - Can only install one of: symfony/console[v3.3.3, v4.0.6].
    - Can only install one of: symfony/console[v3.3.4, v4.0.6].
    - Can only install one of: symfony/console[v3.3.5, v4.0.6].
    - Can only install one of: symfony/console[v3.3.6, v4.0.6].
    - Can only install one of: symfony/console[v3.3.7, v4.0.6].
    - Can only install one of: symfony/console[v3.3.8, v4.0.6].
    - Can only install one of: symfony/console[v3.3.9, v4.0.6].
    - Can only install one of: symfony/console[v3.4.0, v4.0.6].
    - Can only install one of: symfony/console[v3.4.1, v4.0.6].
    - Can only install one of: symfony/console[v3.4.2, v4.0.6].
    - Can only install one of: symfony/console[v3.4.3, v4.0.6].
    - Can only install one of: symfony/console[v3.4.4, v4.0.6].
    - Can only install one of: symfony/console[v3.4.5, v4.0.6].
    - Can only install one of: symfony/console[v3.4.6, v4.0.6].
    - Installation request for symfony/console (locked at v4.0.6) -> satisfiable by symfony/console[v4.0.6].


Installation failed, reverting ./composer.json to its original content.

It appears that @vamsweth was able to work around the issue somehow as noted in #32, but the solution is not clear to me.

[jpkare]

Same problem. Is it possible to update package to use symfony/console v4.0.8?

[sonnysavage]

@jpkare I gave up on using this project.

I discovered pt-table-sync in the Percona Toolkit, and started testing that solution, but my data just changed too frequently for that to work well.

As you can see from the Stack Overflow post I created, I ended up using Percona XtraBackup to do daily full backups and restore my development environment with those. I'm using Amazon S3 for the backup file storage. Restoring my development environment takes about a minute and a half, which includes:

• download the backup archive
• unpack the archive
• stop Laravel
• stop MySQL
• delete MySQL files
• move in new MySQL files
• start MySQL
• start Laravel
• remove the archive

[jpkare]

Thanks @sonnysavage. In my case, I need to sincro a few tables to execute some data elaboration tasks in a Laravel environment. I think db-sync do my case.
@mrjgreen is it possible to upgrade package to use symfony/console v4.0.8?

Thanks in advance.

[sayajin101]

I have the same issue, please advise @mrjgreen