spatie/db-dumper

What's Changed

• Bump dependabot/fetch-metadata from 2.5.0 to 3.0.0 by @dependabot[bot] in #244
• Bump dependabot/fetch-metadata from 3.0.0 to 3.1.0 by @dependabot[bot] in #245
• Fix grammar in DumpFailed exception message by @Warbs816 in #246

New Contributors

• @Warbs816 made their first contribution in #246

Full Changelog: 4.1.0...4.1.1

What's Changed

• Bump dependabot/fetch-metadata from 2.5.0 to 3.0.0 by @dependabot[bot] in https://github.com/spatie/db-dumper/pull/244
• Bump dependabot/fetch-metadata from 3.0.0 to 3.1.0 by @dependabot[bot] in https://github.com/spatie/db-dumper/pull/245
• Fix grammar in DumpFailed exception message by @Warbs816 in https://github.com/spatie/db-dumper/pull/246

New Contributors

• @Warbs816 made their first contribution in https://github.com/spatie/db-dumper/pull/246

Full Changelog: https://github.com/spatie/db-dumper/compare/4.1.0...4.1.1

What's Changed

• Downgrade PHP requirement from ^8.4 to ^8.3 by @erikn69 in #243

What's Changed

• Downgrade PHP requirement from ^8.4 to ^8.3 by @erikn69 in https://github.com/spatie/db-dumper/pull/243

Breaking Changes

• Require PHP 8.4+
• Removed hidden illuminate/support dependency — getSSLFlag() no longer uses DB::selectOne() to auto-detect MySQL version. It now defaults to ssl-mode=DISABLED (works on MySQL 5.7.11+ and required for 8.4+). Use setSslFlag('skip-ssl') if you need the old flag for older MySQL versions.

Added

• includeRoutines() method for MySQL and MariaDB to include stored procedures and functions in dumps
• excludeTablesData() method for MySQL and MariaDB to exclude data for specific tables while keeping their structure
• PHPStan static analysis at max level

Changed

• Upgraded to Pest 4
• Refactored codebase to use promoted constructor properties and standardized naming
• Added array type annotations throughout the codebase

Full Changelog: 3.8.3...4.0.0

Breaking Changes

• Require PHP 8.4+
• Removed hidden illuminate/support dependency — getSSLFlag() no longer uses DB::selectOne() to auto-detect MySQL version. It now defaults to ssl-mode=DISABLED (works on MySQL 5.7.11+ and required for 8.4+). Use setSslFlag('skip-ssl') if you need the old flag for older MySQL versions.

Added

• includeRoutines() method for MySQL and MariaDB to include stored procedures and functions in dumps
• excludeTablesData() method for MySQL and MariaDB to exclude data for specific tables while keeping their structure
• PHPStan static analysis at max level

Changed

• Upgraded to Pest 4
• Refactored codebase to use promoted constructor properties and standardized naming
• Added array type annotations throughout the codebase

What's Changed

• Fix MariaDb ssl flag by @sgilberg in #237

New Contributors

• @sgilberg made their first contribution in #237

Full Changelog: 3.8.2...3.8.3

What's Changed

• Fix MariaDb ssl flag by @sgilberg in https://github.com/spatie/db-dumper/pull/237

New Contributors

• @sgilberg made their first contribution in https://github.com/spatie/db-dumper/pull/237

Full Changelog: https://github.com/spatie/db-dumper/compare/3.8.2...3.8.3

What's Changed

• added ssl flag override to allow for custom server flags by @aschkenasy in #236

New Contributors

• @aschkenasy made their first contribution in #236

Full Changelog: 3.8.1...3.8.2

What's Changed

• added ssl flag override to allow for custom server flags by @aschkenasy in https://github.com/spatie/db-dumper/pull/236

New Contributors

• @aschkenasy made their first contribution in https://github.com/spatie/db-dumper/pull/236

Full Changelog: https://github.com/spatie/db-dumper/compare/3.8.1...3.8.2

What's Changed

• Bump dependabot/fetch-metadata from 2.3.0 to 2.4.0 by @dependabot[bot] in #221
• Update issue template by @AlexVanderbist in #224
• refactor: combine string replacements in PostgreSQL escape method by @Ayoub-Mabrouk in #229
• refactor: optimize empty value check in configureFromDatabaseUrl by @Ayoub-Mabrouk in #230
• refactor: use PHP_OS_FAMILY for Windows detection by @Ayoub-Mabrouk in #231
• Added Symfony 8 support to all symfony/* packages. by @thecaliskan in #232
• Bump actions/checkout from 4 to 6 by @dependabot[bot] in #233
• Bump stefanzweifel/git-auto-commit-action from 5 to 7 by @dependabot[bot] in #225

Full Changelog: 3.8.0...3.8.1

What's Changed

• Bump dependabot/fetch-metadata from 2.3.0 to 2.4.0 by @dependabot[bot] in https://github.com/spatie/db-dumper/pull/221
• Update issue template by @AlexVanderbist in https://github.com/spatie/db-dumper/pull/224
• refactor: combine string replacements in PostgreSQL escape method by @Ayoub-Mabrouk in https://github.com/spatie/db-dumper/pull/229
• refactor: optimize empty value check in configureFromDatabaseUrl by @Ayoub-Mabrouk in https://github.com/spatie/db-dumper/pull/230
• refactor: use PHP_OS_FAMILY for Windows detection by @Ayoub-Mabrouk in https://github.com/spatie/db-dumper/pull/231
• Added Symfony 8 support to all symfony/* packages. by @thecaliskan in https://github.com/spatie/db-dumper/pull/232
• Bump actions/checkout from 4 to 6 by @dependabot[bot] in https://github.com/spatie/db-dumper/pull/233
• Bump stefanzweifel/git-auto-commit-action from 5 to 7 by @dependabot[bot] in https://github.com/spatie/db-dumper/pull/225

Full Changelog: https://github.com/spatie/db-dumper/compare/3.8.0...3.8.1

What's Changed

• Adds simple MariaDB class by @nbyloff in #220

New Contributors

• @nbyloff made their first contribution in #220

Full Changelog: 3.7.2...3.8.0

What's Changed

• Adds simple MariaDB class by @nbyloff in https://github.com/spatie/db-dumper/pull/220

New Contributors

• @nbyloff made their first contribution in https://github.com/spatie/db-dumper/pull/220

Full Changelog: https://github.com/spatie/db-dumper/compare/3.7.2...3.8.0

What's Changed

• Bump dependabot/fetch-metadata from 2.2.0 to 2.3.0 by @dependabot in #217
• Add append mode by @LBannenberg in #219

New Contributors

• @LBannenberg made their first contribution in #219

Full Changelog: 3.7.1...3.7.2

What's Changed

• Bump dependabot/fetch-metadata from 2.2.0 to 2.3.0 by @dependabot in https://github.com/spatie/db-dumper/pull/217
• Add append mode by @LBannenberg in https://github.com/spatie/db-dumper/pull/219

New Contributors

• @LBannenberg made their first contribution in https://github.com/spatie/db-dumper/pull/219

Full Changelog: https://github.com/spatie/db-dumper/compare/3.7.1...3.7.2

What's Changed

• Run tests against PHP 8.3, 8.4 too by @erikn69 in #215
• Update MySql.php by @diadal in #216

Full Changelog: 3.7.0...3.7.1

What's Changed

• Run tests against PHP 8.3, 8.4 too by @erikn69 in https://github.com/spatie/db-dumper/pull/215
• Update MySql.php by @diadal in https://github.com/spatie/db-dumper/pull/216

Full Changelog: https://github.com/spatie/db-dumper/compare/3.7.0...3.7.1

What's Changed

• Bump dependabot/fetch-metadata from 2.0.0 to 2.1.0 by @dependabot in #209
• Bump dependabot/fetch-metadata from 2.1.0 to 2.2.0 by @dependabot in #211
• Update MySql.php by @diadal in #213

New Contributors

• @diadal made their first contribution in #213

Full Changelog: 3.6.0...3.7.0

What's Changed

• Bump dependabot/fetch-metadata from 2.0.0 to 2.1.0 by @dependabot in https://github.com/spatie/db-dumper/pull/209
• Bump dependabot/fetch-metadata from 2.1.0 to 2.2.0 by @dependabot in https://github.com/spatie/db-dumper/pull/211
• Update MySql.php by @diadal in https://github.com/spatie/db-dumper/pull/213

New Contributors

• @diadal made their first contribution in https://github.com/spatie/db-dumper/pull/213

Full Changelog: https://github.com/spatie/db-dumper/compare/3.6.0...3.7.0

What's Changed

• Bump dependabot/fetch-metadata from 1.6.0 to 2.0.0 by @dependabot in https://github.com/spatie/db-dumper/pull/205
• add doNotDumpData() for MySQL and Postgres by @jbraband in https://github.com/spatie/db-dumper/pull/208

New Contributors

• @jbraband made their first contribution in https://github.com/spatie/db-dumper/pull/208

Full Changelog: https://github.com/spatie/db-dumper/compare/3.5.0...3.6.0

What's Changed

• feat: :tada: Add Feature to Skip AUTO_INCREMENT Values in MySQL Dumps by @jhonymiler in https://github.com/spatie/db-dumper/pull/207

New Contributors

• @jhonymiler made their first contribution in https://github.com/spatie/db-dumper/pull/207

Full Changelog: https://github.com/spatie/db-dumper/compare/3.4.3...3.5.0

What's Changed

• Allow set dump binary path with empty value by @mokhosh in https://github.com/spatie/db-dumper/pull/206

New Contributors

• @mokhosh made their first contribution in https://github.com/spatie/db-dumper/pull/206

Full Changelog: https://github.com/spatie/db-dumper/compare/3.4.2...3.4.3

What's Changed

• Bump stefanzweifel/git-auto-commit-action from 4 to 5 by @dependabot in https://github.com/spatie/db-dumper/pull/201
• Bump actions/checkout from 3 to 4 by @dependabot in https://github.com/spatie/db-dumper/pull/200
• [3.x] Ensure port is a string when creating credentials file for Postgres by @RVxLab in https://github.com/spatie/db-dumper/pull/203

New Contributors

• @RVxLab made their first contribution in https://github.com/spatie/db-dumper/pull/203

Full Changelog: https://github.com/spatie/db-dumper/compare/3.4.1...3.4.2

What's Changed

• Bump dependabot/fetch-metadata from 1.5.1 to 1.6.0 by @dependabot in https://github.com/spatie/db-dumper/pull/198
• Allow symfony/process 7.x by @thecaliskan in https://github.com/spatie/db-dumper/pull/202

New Contributors

• @thecaliskan made their first contribution in https://github.com/spatie/db-dumper/pull/202

Full Changelog: https://github.com/spatie/db-dumper/compare/3.4.0...3.4.1

What's Changed

• Bump dependabot/fetch-metadata from 1.4.0 to 1.5.1 by @dependabot in https://github.com/spatie/db-dumper/pull/194
• Add support for database URLs by @mikerockett in https://github.com/spatie/db-dumper/pull/196

New Contributors

• @mikerockett made their first contribution in https://github.com/spatie/db-dumper/pull/196

Full Changelog: https://github.com/spatie/db-dumper/compare/3.3.1...3.4.0

What's Changed

• PHP 8.2 Build by @erikn69 in https://github.com/spatie/db-dumper/pull/180
• Add Dependabot Automation by @patinthehat in https://github.com/spatie/db-dumper/pull/182
• Bump dependabot/fetch-metadata from 1.3.5 to 1.3.6 by @dependabot in https://github.com/spatie/db-dumper/pull/186
• Convert all tests to Pest by @alexmanase in https://github.com/spatie/db-dumper/pull/188
• Bump actions/checkout from 2 to 3 by @dependabot in https://github.com/spatie/db-dumper/pull/183
• Bump dependabot/fetch-metadata from 1.3.6 to 1.4.0 by @dependabot in https://github.com/spatie/db-dumper/pull/191
• Update command to use doublequotes for username by @applyACS in https://github.com/spatie/db-dumper/pull/192

New Contributors

• @dependabot made their first contribution in https://github.com/spatie/db-dumper/pull/186
• @alexmanase made their first contribution in https://github.com/spatie/db-dumper/pull/188
• @applyACS made their first contribution in https://github.com/spatie/db-dumper/pull/192

Full Changelog: https://github.com/spatie/db-dumper/compare/3.3.0...3.3.1

What's Changed

• Docs: typo in README.md in column_statics by @Ayoub-Mabrouk in https://github.com/spatie/db-dumper/pull/175
• add excludeTables support for sqlite by @ariaieboy in https://github.com/spatie/db-dumper/pull/177

New Contributors

• @Ayoub-Mabrouk made their first contribution in https://github.com/spatie/db-dumper/pull/175
• @ariaieboy made their first contribution in https://github.com/spatie/db-dumper/pull/177

Full Changelog: https://github.com/spatie/db-dumper/compare/3.2.1...3.3.0

What's Changed

• Update .gitattributes by @angeljqv in https://github.com/spatie/db-dumper/pull/167
• Fix: Replaced single quotes in mongodb dump command in windows env by @malconvsilva in https://github.com/spatie/db-dumper/pull/172

New Contributors

• @angeljqv made their first contribution in https://github.com/spatie/db-dumper/pull/167
• @malconvsilva made their first contribution in https://github.com/spatie/db-dumper/pull/172

Full Changelog: https://github.com/spatie/db-dumper/compare/3.2.0...3.2.1

• Add includeTables support for Sqlite

Full Changelog: https://github.com/spatie/db-dumper/compare/3.0.1...3.1.0

• remove type declaration that causes errors (#151)

• require PHP 8+
• drop all PHP 7.x support
• use PHP 8 syntax
• add Bzip2Compressor to allow use of the bzip2 compression utility

• fix attempt to generate dump over http connection when using socket (#145)

• fix: make the process more extensible, avoid touching anything (#141)

• revert changes in 2.19.0

• fix: add some public functions that allow extensibility (#139)

• support PHP 8

• add doNotUseColumnStatistics

• fix using gzip compression on windows (#130)

• allow for adding options after the db name (#129)

• Fix incomplete credential guard (#126)

• Fix sqlite3 dump on Windows

• add doNotCreateTables to Postgres driver (#116)

• fix memory leak (issue #109)

• Determine quotes for windows for MongoDB and PostgreSql dumps (#107)

• wrap the dump command in an if statement when using compression (#100)
• drop support for PHP 7.2 and lower

• add --skip-lock-tables and --quick option (#95)

• fix process warnings

• remove pipefail operator when compressing dump

• add ability to specify all databases as MySQL option

• add doNotCreateTables

• add useExtension

• add Compressor

• allow destination paths to have a space character

• add support for compressing dumps

• add support for setting --set-gtid-purged

• add support for Symfony 4

• fix SQLite dump

• add setAuthenticationDatabase

• fix for dumping a MongoDB without username or password

• allow empty passwords for MongoDB dumps

• make --databases optional

• made option passing more flexible by adding --databases option to the MySQL dumper

• MongoDb dumps won't be compressed by default anymore
• add enableCompression on MongoDb

• fix sqlite dumper

• add support for MongoDB

• prefix excluded tables with database name when dumping a MySql db