- [FEATURE] Add dbCodeFilter option to filter database (credits to SimonVanacco )
- [BUGFIX] SSL options in drop tables command (credits to maikschneider )
- [BUGFIX] Make strict boolean conditions for
post_sql_in_markersandpost_sql_in. - [BUGFIX] Fix the logic for resolving PHP binary. If the binary specified by
php_versionorcomposer.jsonis not found, it now gracefully falls back to search forphpbinary and finally defaults to plainphp.
- [BUGFIX] Fix the way the
local/bin/phpis determined.
- [TASK][BREAKING] Use new version of
sourcebroker/deployer-instance. This version has fallback when no .env (or .env.local) file exists. It will take the system variables then. This should not break anything, but anyway a major version just to be sure.
- [BUGFIX] Fix wrong use of
bin/phpfor local context. Deployerbin/php, when not a explicitly set as string, is usingwhich()function, that is usingrun()in background, which is trying to make connection to local ssh. This fix useslocal/bin/phpinstead which will check locally: firstphp_versionsetting of host, then if not found it will checkcomposer.jsonfor the php version. If php version is found, then the binary will be searched first for X.Y (like 8.4) and then for XY (84). Finally ifphp_versionorcomposer.jsondo not give answer about php version it will fallback just to searchphpbinary. - [BUGFIX] Fix some edge cases for replacing the task names in nested outputs.
- [BUGFIX] Remove using "stat" command in
db:downloadanddb:uploadcommands because not available on some systems. Usefilesize()from php as command is run locally, useglob()instead oflsas for the same reason. Fix the files size calculation. - [FEATURE] Add options to disable task infos:
db_download_info_enable,db_upload_info_enable,db_import_big_table_info_enable,db_pull_from_local_storage_info_enable. By default, they all are enabled. - [BUGFIX][BREAKING] Fix wrong name of option in db:import task. It was
db_import_show_ignore_tables_output_max_line_lengthbut should bedb_import_big_table_output_max_line_length. Rename optiondb_export_mysqldump_show_ignore_tables_outtodb_export_mysqldump_show_ignore_tables_out_info_enablein db:export. Change default value ofdb_export_mysqldump_show_ignore_tables_out_max_line_lengthfrom 250 to 120. - [TASK] Add
localhost('local')by default.
- [TASK] Extend the dependency to v5 of
sourcebroker/deployer-loader.
- [BUGFIX] Last line of ignored tables at db:export task was not shown. This change fix this and also make refactor for this part.
- [FEATURE] Allow to add custom options to
--options=. If option has prefixtxis not validated. For example--options=txMyOption:myValue.
- [BUGFIX] The constant GLOB_BRACE is not defined on all systems, like fe Alpine Linux. After this fix GLOB_BRACE is no longer used.
- [BUGFIX] Fix the condition for checking if release_path exists. It was failing when
db:backupat localhost was invoked becauserelease_pathis not set then. Replace with usage ofdeploy_pathand hardcodedrelease.
- [BUGFIX] Fix wrong condition on
db:backup. After this fix tags "release" and "release_X" will be automatically added when taskdb:backupis run during deploy beforedeploy:symlink.
- [BUGFIX] PHP 7.4 compatibility fixes.
- [TASK][BREAKING] Change the default charset for mysql/mysqldump operations from utf8 to utf8mb4.
- [TASK] Add output formatting helper functions in ConsoleUtility.
- [FEATURE] Add way to validate value of single
--optionswith preg_match in ConsoleUtility->getOption. - [TASK][BREAKING] Add preg_match for dumpcode
/^[a-zA-Z0-9_]+$/ - [TASK] Add support for resolving home in deploy_path
- [TASK][BREAKING] Remove autocreation of dumpcode on db:export. Since now you need to add your dumpcode with --options=dumpcode:mydumpcode
- [TASK] Move db credentials to temporary file and use it with
--defaults-file=. Reason is edge case thatMYSQL_PWDwas overwritten by~/.my.cnffiles. For example: ddev/ddev#6851 - [FEATURE] Add info about big tables on db:import. Useful to fast check if we import some not needed big tables.
Default limit is 50MB. You can change it to your value in
db_import_big_table_size_threshold. - [FEATURE] Add info about ignored tables on mysqldump in db:export. You can configure max_line in
db_export_mysqldump_show_ignore_tables_out_max_line_length. - [TASK][BREAKING] Change bahaviour of
db:downloadanddb:upload. Option--remove-source-fileshas been removed from rsync and downloaded, uploaded files are not longer automatically removed. Add short info about size of downloaded or uploaded file. - [TASK] Show
db:dumpcleanoutput only when verbosity higher than regular. - [TASK][BREAKING] Change behaviour of
db:copy,db:pull,db:push. No longer copy of imported database is kept in database storage. This is clean up before implementing a backup of replaced database. Add nice formatting of tasks with info about ignored tables, size od downloaded/uploaded database and too big tables. - [FEATURE] Add command
db:import:lastto import last downloaded database. Bring back keeping last imported databases and rotation of those. - [FEATURE] Add validation for name of options. If name is wrong task will stop.
- [TASK][BREAKING] Move normalizeFolder functionality into 'db_storage_path_local' function as it was used only in this context. Remove FileUtility->normalizeFolder
- [TASK][BREAKING] Do not throw error in db:decompress task if dump is already decompressed.
- [TASK] Add new OptionUtility for managing "--options". Add new option "tags" that allow to set tags for dump filename.
- [TASK] Refactor db:copy, db:pull, db:push. Store copies of dumps that will be imported and store dump of local database before import. This will allow to recover when database overwritten by accident. Add tags to dumps.
- [TASK][BREAKING] Remove db:import:last task in favour of option for db:pull.
- [TASK][BREAKING] Remove dependency to symfony/dotenv.
- [FEATURE] Add support for SSL connection to database.
- [FEATURE] Add missing variable for mysql options for post sql import
db_import_mysql_options_post_sql_in.
- [FEATURE] Add possibility to overwrite
db_databasesby settingdb_databases_globalanddb_databases(on host level). See more on UPGRADE file.
- [BUGFIX] Fix connectionOptionsString() is already escapeshellarg'ed on RsyncUtility->getSshOptions.
- [TASK][BREAKING] Bump dependency to
sourcebroker/deployer-instance. - [TASK] Code cleanup / update readme.
- [BUGFIX] Fix wrong function used to output text.
- [TASK][BREAKING] Refactor to Deployer 7.
- [TASK] Extend dependency to internal packages to dev-master.
- [TASK][BREAKING] Update dependency to
sourcebroker/deployer-loaderwhich introduce load folder/files alphabetically.
- [BUGFIX] Use port-parameter in mysqli_connect (tnx to mavolkmer)
- [TASK] Drop styleci.
- [TASK] Drop date from licence.
- [BUGFIX] Add dependency to sourcebroker/deployer-instance (fix compatibility with symfony/dotenv 5.0)
- [TASK] Add ddev config.
- [TASK][BREAKING] Fix compatibility with symfony/dotenv 5.0 which do not use getenv() by default.
- [BUGFIX] Fix changelog typo.
- [TASK] Increase symfony/dotenv version.
- [FEATURE] Use loadEnv function from SymfonyDotenv if possible.
- [BUGFIX] Documentation bugfixes.
- [TASK][BREAKING] Add new default option for mysqldump '--no-tablespaces' . https://dba.stackexchange.com/questions/271981/access-denied-you-need-at-least-one-of-the-process-privileges-for-this-ope
- [BUGFIX] Fix for normalize file regexp.
- [BUGFIX] Force dumpcode to be only a-z, A-Z, 0-9, _.
- [TASK][BREAKING] Add dependency to deployer-extended-loader.
- [BUGFIX] Force dumpcode to be only a-z, A-Z, 0-9.
- [BUGFIX] Fix for normalize file regexp.
- [FEATURE] Add db:push command.
- [FEATURE] Add FileUtility->locateLocalBinaryPath.
- [TASK][BREAKING] Remove not needed dependency to deployer-extended-loader.
- [TASK][BREAKING] Cleanup variables naming.
- [TASK] Protect copying/pushing/pulling database to top level instance.
- [TASK] Disable default command for db_process_commands.
- [TASK][BREAKING] Compatibility with Deployer 6.4+
- [TASK][BREAKING] Refactor options to single option --options=key:value,key:value
- [TASK] Use $host->getSshArguments()->getCliArguments() for creating rsync ssh parameters.
- [FEATURE] Add option exportTaskAddIgnoreTablesToStructureDump to allow to add ignore tables when exporting structure.
- [FEATURE] Add option importTaskDoNotDropAllTablesBeforeImport to prevent dropping all tables before import.
- [TASK] Add vendor and composer.lock to .gitignore.
- [FEATURE][BREAKING] Implement sourcebroker/deployer-instance for instance management.
- [BUGFIX] Remove colon from file names because if Windows compatibility.
- [TASK] Replace RuntimeException with GracefulShutdownException.
- [TASK] Increase version of sourcebroker/deployer-instance.
- [TASK] Replace hardcoded instance name with var.
- [TASK] Normalize use of dots at the end of task description.
- [BUGFIX] Replace ":" with "=" because Windows compatibility - date separated by ":".
- [BUGFIX] Replace ":" with "=" because Windows compatibility.
- [TASK][BREAKING] Possible breaking change for those using global
depinstead of that one in./vendor/bin/depaslocal/bin/deployeris set now to./vendor/bin/dep.
- [BUGFIX] If publicUrl is with port then this port should be also used for post_sql_in_markers.
- [FEATURE] Add confirmation for command db:copy (tnx to Michał Jankiewicz)
- [FEATURE] Add default option to confirmation for command db:copy so it can be used also with -q option for unattended.
- [BUGFIX] Fix $dbDumpCleanKeep calculation in db:dumpclean.
- [BUGFIX] Move count() out of for so its not calculated each time.
- [FEATURE] Add
db:dumpcleantask. Adddb:dumpcleanas last task todb:backupanddb:pull. Add docs.
- [BREAKING] Remove
db_deployer_versionconfig var as its not needed for deployer/distribution based version now. - [DOCS] Change to number ordered list on CHANGELOG.rst.
- [TASK] Rename
typetoabsolutePathin $mysqlDumpArgs of db:export so it have more meaning. - [TASK] Improve tasks descriptions.
- [FEATURE] Add db:compress and db:decompress tasks and extend docs.
- [TASK] Cleanup for db:upload, db:download tasks.
- [FEATURE] Compress local dumps after importing them with
db:pull [instance]. - [FEATURE] Add db:rmdump task and documentation.
- [FEATURE] Add db:rmdump task at the end of
db:copy [source] [target]task. - [FEATURE] Add db:backup task.
- [BUGFIX] Fix styles ci.
- [BUGFIX] Do not show error on database pull if
public_urlsare not set.
- [BUGFIX] Remove not needeed exeption throws as the truncate_tables value can be
- not set or return empty value from regexp.
- [BUGFIX] Add missing dependency to sourcebroker/deployer-loader
- [TASK] Add dependency to sourcebroker/deployer-loader
- [TASK][!!!BREAKING] Remove SourceBrokerDeployerExtendedDatabaseLoader.php in favour of using sourcebroker/deployer-loader
- [TASK][!!!BREAKING] Remove SourceBrokerDeployerExtendedDatabaseUtilityFileUtility->requireFilesFromDirectoryReqursively because it was used only in SourceBrokerDeployerExtendedDatabaseLoader.php
- [BUGFIX] Fix wrongly prepared marker domainsSeparatedByComma when more than one domain
- [TASK] Make dependency to deployer/deployer-dist.
- [TASK] Make
bin/deployeruse of vendor/bin/dep from deployer-dist.
- [BUGFIX] Fix rebulding symlink to deployer.phar
- [BUGFIX] Fix wrong path set for db:copy
- [TASK] db:export refactor: add possibility to call command on remote instance, add
db_export_mysqldump_options_structureanddb_export_mysqldump_options_dataenv. - [BUGFIX] Fix wrong changlog address in main docs.
- [TASK] db:truncate refactor add escapeshellargs
- [TASK] Escapeshellargs for all commands
- [TASK][BREAKING] Change static utilities method calls to regular objects method call.
- [TASK] Cleanup
db:downloadanddb:uploadtasks with RsyncUtility - [TASK][BREAKING] Rename var
bin/mysqltolocal/bin/mysql - [TASK] Refactor db:import
- [TASK] db:import refactor add possibility to call command on remote instance
- [TASK] Enable duplication check for scrutinizer.
- [TASK] Pass verbosity to commands run locally in db:pull task.
- [TASK] Move mysql options from db:import task to variables.
- [TASK] Pass verbosity to commands run locally with use of ConsoleUtility.
- [TASK] Implement optionRequired() in ConsoleUtility.
- Set
default_stageas callable. This waydefault_stagecan be now overwritten in higher level packages.