m12/neos-plugin-dbexport

DB Utils to export/import whole Neos database

M12.DbExport - Neos plugin to import/export database

Does a full or partial (content-only tables) database dump into .sql file. It adds db:export and db:import commands to ./flow., _(*1)

It might be considered as a temporary workaround to sometimes faulty ./flow site:export and ./flow site:import commands., _(*2)

By default it exports only "content" tables listed in Settings.yaml, unless you specify --mode=all., _(*3)

Installation

composer require m12/neos-plugin-dbexport:dev-master, _(*4)

Usage

Export

./flow db:export --package-key Your.SitePackage [--mode=content]
to have a .sql dump in Your.SitePackage/Private/Resources/Content/Content.sql, _(*5)

./flow db:export --package-key Your.SitePackage [--mode=all]
to have a .sql dump in Your.SitePackage/Private/Resources/Content/Dump.sql, _(*6)

You can also specify path where the .sql file will be exported:
./flow db:export --sql-file my-dump.sql [--mode=content|all], _(*7)

Import

Caveat: import process will drop and override the tables, therefore make sure you won't press wrong buttons accidentally., _(*8)

./flow db:import --sql-file my-dump.sql
to simply import selected .sql file., _(*9)

./flow db:import --package-key Your.SitePackage
to import Your.SitePackage/Private/Resources/Content/Content.sql, _(*10)

./flow db:import --package-key Your.SitePackage --mode=all
to import Your.SitePackage/Private/Resources/Content/Dump.sql, _(*11)

Author(s)

• Marcin Ryzycki marcin@m12.io