Db Dumper Laravel Package

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

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 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 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 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 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 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 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

• allow symfony 5 components

• 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

• add --default-character-set option for MySql
• improve the preservation of the used charset when dumping a MySql db

• fix bug where custom binary path with spaces on linux would not process correctly

• add skipComments

• add support for SQLite

• made a change so the package can be used on Windows

• added getHost

• fix for dump paths with spaces

• refactored all classes
• added the ability to add artribrary options

• Removed -d flag from pg_dump for compability with pgsql 7.3+

• Added includeTables and excludeTables

• Added --single-transaction option to Mysql dump command

• Added the ability to use insert when dumping a PostgreSQL db

• Added more details about a dump failure in the error message

• Fixed an issue where paths containing spaces would cause problems

• Added an option to set a timeout

• Fixed PostgreSQL dump

• Added support for PostgreSQL

• Lowered PHP and symfony requirements

• Fixed a bug when the backup has failed.

• Added missing abstract getDbName-method

• Added missing abstract dumpToFile-method

• Fixed typo in checkIfDumpWasSuccessFul-method name
• Fixed bug running Process

• Initial release

• Fixes for vendor by @erikn69 in https://github.com/spatie/db-dumper/pull/159
• Allow symfony v6 by @Nielsvanpach

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

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