lordsimal / cakephp-dump-sql
A CakePHP 4 plugin to export SQL
Installs: 2 620
Dependents: 0
Suggesters: 0
Security: 0
Stars: 4
Watchers: 1
Forks: 0
Open Issues: 0
Type:cakephp-plugin
Requires
- php: >=8.1
- cakephp/cakephp: ^5.0.0
- symfony/process: ^5.4
Requires (Dev)
- cakephp/cakephp-codesniffer: ^5.0
- phpunit/phpunit: ^10.1
This package is auto-updated.
Last update: 2024-11-17 08:38:16 UTC
README
This plugin adds a CakePHP command to easily generate SQL dumps of your configured datasources
Currently the following DBMS are integrated:
- MySQL/MariaDB
- SQLite
- PostgreSQL
Version table
Installation
The recommended way to install this plugin via composer is:
composer require lordsimal/cakephp-dump-sql --dev
Then execute
bin/cake plugin load CakeDumpSql
or add this to your src/Application.php
manually
public function bootstrap(): void
{
parent::bootstrap();
// Other plugins
$this->addPlugin('CakeDumpSql');
}
Requirements
For each DBMS you need to have its respective dump tool installed.
- MySQL/MariaDB =>
mysqldump
- SQLite =>
sqlite3
- PostgreSQL =>
pg_dump
⚠️ For pg_dump
it is especially important that you have a compatible version installed. So e.g. if you have a PostgreSQL 14 server you need a pg_dump version 14 ⚠️
How to use
After installing the plugin you now have a new command available to you:
bin/cake dump_sql
After executing that command you should see a SQL representation of your default
datasource inside your console.
So if you want to save it into a file you should do
bin/cake dump_sql > dump.sql
Dump different datasource
You can specify which datasource you want to export via the first argument
bin/cake dump_sql test > test_dump.sql
GZIP compressed dump
ℹ️ The following feature requires you have the PHP zlib extension installed and active ℹ️
bin/cake dump_sql --gzip > dump.sql.gz
Data only dump
bin/cake dump_sql --data-only > data.sql