db_export_ui
A lightweight Drupal module that provides a simple administrative interface for exporting MySQL/MariaDB database dumps.
This module is intended for developers and site maintainers who need a minimal database export tool with basic sanitization capabilities and who prefer a small codebase that can be easily customized for project-specific workflows.
When should I use this module?
Database Export UI is designed for simple use cases where you need:
- A single-click database export from the Drupal admin UI
- SQL dump generation using mysqldump
- Basic user data sanitization before sharing dumps
- A small, developer-friendly codebase that can be extended or customized
Similar projects
When should I use Backup and Migrate instead?
For most production websites, the Drupal Backup and Migrate module is likely the better choice.
Backup and Migrate provides:
- Scheduled backups
- Multiple storage destinations
- Restore functionality
- Selective table exports
- Advanced backup profiles
- Long-term maintenance and broad community adoption
Database Export UI does not attempt to replace Backup and Migrate. Instead, it provides a lightweight alternative for projects that only require a simple export workflow.
Features
- Export database directly from Drupal admin UI
- Generate compressed.sql.gz dumps
- Optional user data sanitization
- Drupal 10 and 11 compatible
- Uses Drupal services and dependency injection
Requirements
- Drupal 10 or 11
- PHP 8.1+
- MySQL / MariaDB
Installation
drush en db_export_ui -y
Navigate to: /admin/config/development/db-export
Limitations
- Supports MySQL/MariaDB only
- Does not provide restore functionality
- Does not provide scheduled backups
- Does not support remote backup destinations
- Sanitization is intentionally basic and may need customization for project-specific requirements
Intended Audience
This module is primarily intended for:
- Local development environments
- Internal development teams
- Custom distributions requiring a simple export workflow
- Projects that want a lightweight starting point for custom database export tooling