
DB Dumper
acpl/flarum-db-dumper
Dump the contents of a Flarum database
- Downloads
- 37
- Version control
- github.com/android-com-pl/flarum-db-dumper
Flarum Database Dumper
Database backup extension for Flarum that allows dumping database content using the db:dump
command.
Installation
composer require acpl/flarum-db-dumper
Usage
Basic usage:
# Dump to storage/dumps/dump-YYYY-MM-DD-HHMMSS.sql
php flarum db:dump
# Dump to specific path/file
php flarum db:dump /path/to/backup.sql
php flarum db:dump ../backups/forum.sql
# Dump with compression (based on extension)
php flarum db:dump /backups/dump.sql.gz # gzip compression
php flarum db:dump /backups/dump.sql.bz2 # bzip2 compression
# Create backup on live site without locking tables
php flarum db:dump --single-transaction --quick --lock-tables=false
Options
-
--compress
: Use compression (gz
orbz2
), e.g.--compress=gz
for gzip -
--include-tables=table1,table2
: Include only specific tables -
--exclude-tables=table1,table2
: Exclude specific tables -
--skip-structure
: Skip table structure -
--no-data
: Skip table data, dump only structure -
--skip-auto-increment
: Skip AUTO_INCREMENT values -
--no-column-statistics
: Disable column statistics (for MySQL 8 compatibility) -
--binary-path=/path/to/binary
: Custom mysqldump binary location
Additionally, most of the standard mysqldump options are supported (like --single-transaction
, --quick
, --lock-tables
, etc).
Check mysqldump documentation for available options.
Requirements
-
mysqldump
binary -
gzip
for.gz
compression -
bzip2
for.bz2
compression
Links
Versions
-
Version v1.0.2.
Likely works with Flarum v1.8.9.
Unlikely to work with Flarum v2.0.0-beta.2.
-
3 additional versions.
-
Extension created.