This is a re-release of 1.16.1, but this time with a fixed build process so that a PHAR file should be provided again.

What's Changed

• Deaktiviere XDebug in GitHub Actions (Case 168925) by@mpdude in#110
• Aktualisiere PHP-CS-Fixer auf v3.62.0 by@mpdude in#111
• Improve support for PHPUnit 10, dropping older by@MalteWunsch in#115
• Fix: Use configured replacements when dumping table rows in CSV by@MalteWunsch in#116

Full Changelog:1.16.0...1.16.1

Contributors

This version drops support for PHP versions below 8.1 (#107). This allows us to update the dependencies bundled into the.phar version, and allowsslimdump to be installed as a Composer dependency in your project alongside current versions of other libraries used (#108).

What's Changed

• Fill in dummy types to deal with DC2:... column comments by@mpdude in#102
• Update to use actions/checkout v4 by@mpdude in#105
• Update GHA workflows to use current Ubuntu and tools versions by@mpdude in#106

Full Changelog:1.15.0...1.15.1

Contributors

What's Changed

• Dump the character set as specified for the connection by@mpdude in#101

Full Changelog:1.14.1...1.15.0

Contributors

Since the addition of the CSV output mode in the 1.14.0 release,TRIGGER definitions were (unintentionally) dumped before the data for a table. In previous releases, theyfollowed theINSERT statements.

Creating triggers before loading the data may be a problem when the trigger fires and not all tables have been created or locked at that time, so this change was reverted (#100).

What's Changed

• Update toactions/checkout@v3 by@mpdude in#97
• Update PHP-CS-Fixer to v3.11 by@mpdude in#98
• Update actions/cache to v3 by@mpdude in#99
• Dump TRIGGER definitionsafter data by@mpdude in#100

Full Changelog:1.14.0...1.14.1

Contributors

The main new feature of this release is a new output mode for CSV files (#92).

The new command option--output-csv=... enables CSV output mode, and must be given the path to a directory. The output mode will create .csv files in the given directory, named according to the dumped tables.

This output format does not support output redirection from stdout as the default MySQL SQL format does.

CSV files will be created only for tables that contain data. In other words, schema type dumps will skip the table in question. Also, dumping views/triggers makes no sense for CSV files, they will be skipped as well.

How to best write binary (BLOB) data and/or NULL values in CSV files is probably highly controversial. For now, we'll just go with the0x... hex literals supported by MySQL. Maybe having binary data in CSV files is not a sane idea in the first place.

Also, the exact details of the CSV format might still change, so consider this feature as experimental.

Full list of changes

• Run GitHub Actions Workflows on Ubuntu 20.04@mpdude in#87
• Bump dependencies, update test matrix by@mpdude in#91
• RemoveDumperTest by@mpdude in#90
• Refactor output-format related code into a dedicated class + interface by@FabianSchmick in#88
• Refactor the SlimdumpCommand, DumpTask and Dumper classes by@mpdude in#93
• Remove theDumper::keepalive() method by@mpdude in#94
• Ensure PHP 7.2 compatibility for thecomposer.lock file by@mpdude in#95
• Implement CSV output mode by@FabianSchmick in#92

New Contributors

• @FabianSchmick made their first contribution in#88

Full Diff:1.13.0...1.14.0

Contributors

Themax_execution_time might cause rows to be missing from dumps when PHP < 7.4.13, but could also lead to dumps being aborted for newer PHP versions (#84).

This release disables themax_execution_time timeout value forslimdump's database connection (#86).

Additionally, a warning is printed (#85) when the number of rows dumped does not match the number expected (which is based on aCOUNT(*) query).

Fixes#76

But hopefully, this time a .phar version will be built. 🤞🏻