Download the PHP package sqonk/mysql-sync without Composer

On this page you can find all versions of the php package sqonk/mysql-sync. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of sqonk/mysql-sync

Informations about the package mysql-sync

MySQL Synchroniser

Minimum PHP Version

The MySQL Synchroniser is a simple script written in PHP that can assist and automate the synchronisation of differences in table structures between two database servers.

Synchronisation is performed between a source database and a destination.

Install

Via Composer

Disclaimer - (Common Sense)

Always backup the destination database prior to making any changes, this should go without saying.

Usage

Method 1: Using a JSON config file

First duplicate the sample json sync file provided the conf folder, call it something meanginful and enter the database details for both the source and destination databases.

Note that the above is a baseline config. See the sample json file for a full set of possible options.

Then from your terminal run the following the command:

Method 2: Using in-memory PHP array

Create a new PHP script, load the composer includes and pass your config array accordingly.

Ignoring Column Widths

If you are in a situation in which the configuration of the destination database differs from that of the source environment in such a way that column widths do not match up then you can set the option ignoreColumnWidths to true in the top level of your sync configuration.

This will adjust the comparison to ignore column width/length.

Dealing with Collation differences on tables

If the source and destination databases have different character encoding sets you can instruct the synchroniser to either remove or substitute encoding sets when creating new tables in the destination.

Omitting COLLATE syntax entirely

Add a key omitCollate to the top level of your json config with a value of true or false. Setting it to true will remove all COLLATE= commands on the end of CREATE TABLE lines.

Substituting collation

You can also elect to replace occurances of multiple table collations on your source database to another set that is present on the destination database.

To do so, add the following to the top level of your config, replacing the values of 'from' and 'to':

Because the collateSubstitutions is an array, you can add as many substiution sets as required.

Using both options together

Setting omitCollate to true and adding substitution sets will function as expected; Substitutions will be replace occurances and any collations not matching one of the sets will be removed.

Process

A dry-run will first be performed and any differences will be displayed, including:

Once done, you will be prompted if you wish to apply the changes for real.

Credits

License

The MIT License (MIT). Please see License File for more information.

All versions of mysql-sync with dependencies

PHP Build Version
Package Version
Requires php Version ^8
sqonk/phext-context Version ^0.3.7
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package sqonk/mysql-sync contains the following files

Loading the files please wait ...