Download the PHP package vielhuber/syncdb without Composer
On this page you can find all versions of the php package vielhuber/syncdb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download vielhuber/syncdb
More information about vielhuber/syncdb
Files in vielhuber/syncdb
Package syncdb
Short Description Syncs a database (mysql, pgsql) between two servers (optional via ssh tunnel).
License MIT
Informations about the package syncdb
🔥 syncdb 🔥
syncdb syncs databases between two servers.
Features
- Most common use case: Sync your production database to your local environment
- You also can sync between any servers, even from remote to remote (without local)
- Works with direct database connections or via ssh tunnels
- Currently supports mysql, postgresql support will be added soon
- Has also a fast mode where the sql file is zipped (you also can choose the compression level)
- Does include a search/replace mechanism called magicreplace
- (Remote) commands like mysqldump, mysql, zip, e.g. can be overwritten manually to fit any environment
- Works on Linux, Mac and Windows (with WSL)
- Supports parallel execution of multiple syncs
- Uses optimization techniques for a faster restore
- Also supports ssh connections to servers without the support for public keys
- Shows live restore progress
Requirements
Mac
Install Homebrew and then coreutils:
Windows
Choose one of the two following options:
- Install WSL2
- Install Cygwin:
- Install all default packages +
unzip
- Add
C:\cygwin64\bin
to your environment PATH (high priority, but below php)
- Install all default packages +
Installation
Mac / Windows (WSL2) / Linux
Now add ~/.syncdb/vendor/vielhuber/syncdb/src/
to your path environment.
Windows (CMD)
Now add C:\Users\xxx\.syncdb\vendor\vielhuber\syncdb\src\
to your path environment.
Update
Mac / Windows (WSL2) / Linux
Windows (CMD)
Usage
Configuration
Simply put your desired configuration files in ~/.syncdb/profiles/profile-name.json:
You can find more examples in the profiles folder in this git repo.
Privileges
Since MySQL 5.7 and MySQL 8.0.21 accessing the INFORMATION_SCHEMA.FILES table now requires the PROCESS privilege. Most providers don't have this option available. This results in the error message:
Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
syncdb
automatically adds --no-tablespaces
to your mysqldump-commands. You can turn off this behaviour by adding "tablespaces": true
to your configuration.