Magedbm2 Versions Save

Added Command Line only Support for SSL connections to the database. An optional parameter, db-ssl-ca, is now usable on commandline. Expects Path to SSL CA e.g. /etc/ssl/my-cert.pem

Backward incompatible config fixes and more

PHP 8 compatibility

Fixed

• The s_core_customergroups* tables are no longer removed from when using the platform_shopware table group.

Changed

• Additional tables that are not required for local development environments have been added to platform_shopware to minimmise database sizes.

Added

• New command view-config to dump the current YAML configuration to stdout.
• Added platform_shopware and platform_magento_one table groups because we're using this for more than just Magento 2.x!

Changed

• BREAKING: Renamed tmp_dir configuration option to tmp-dir.
• BREAKING: All MySQL interactions now use utf-8 as the default charset, potentially making backups created with an older versions unimportable. Use --download-only and import manually if you run into this or update on your server and put a new database backup.
• The configure command now presents the user will files to edit and a preview of the changes before writing to file.
• Updated table groups from netz98/n98-magerun2 for Magento 2.x.

Fixed

• The --project-config option is now respected and the configuration file is loaded at the correct time.
• The merging of indexed based configuration items (like adding new table groups) is now fixed.

Fixes:

• The put command no longer performs Magento 2 discovery if the required database options are specified as command-line parameters
• The admin table strip group no longer removes administrator roles, only users

• Strip DEFINER from CREATE TRIGGER statements (#13)
• Don't allow blank --db-* options

This new major release for magedbm2 includes the following:

• Removed dependency on n98-magerun
• Support the generation of an anonymised data export with the export and import commands (great for reproducing those bugs that need the data in your database, without jeopardising your sensitive customer data)
• Add project-level configuration so you can ship a .magedbm2.yml file with your project and add project-specific configuration in there

Since @bobbyshaw released Magedbm for Magento 1.x (https://github.com/meanbee/magedbm) back in 2015 it's become a critical tool in our processes for setting up development and staging environments. Now, thanks to a lot of work from @tgerulaitis, we've got a version for Magento 2.x!