Database Utility
The FileFlows Database Utility is a standalone tool for working with FileFlows databases. It can be used to copy, back up, and restore your FileFlows database across different database engines.
What It Does
The Database Utility can:
- Copy data from one database engine to another (SQLite → MySQL/MariaDB, MySQL → PostgreSQL, PostgreSQL → SQLite, etc.)
- Back up MySQL/MariaDB or PostgreSQL databases to a portable SQLite file
- Restore a SQLite backup into a fresh MySQL/MariaDB or PostgreSQL database
A backup is simply a SQLite file. Since SQLite is already a single-file database, there is no separate "SQLite backup" operation — copying the .sqlite file directly is the backup.
Supported Database Engines
| Engine | Supported As | Supported As |
|---|---|---|
| SQLite | Source ✓ | Target ✓ |
| MySQL / MariaDB | Source ✓ | Target ✓ |
| PostgreSQL | Source ✓ | Target ✓ |
How It Works
The Database Utility operates on a FileFlows database file. When you back up a MySQL or PostgreSQL database, the tool exports the data into a SQLite file that you can store anywhere.
When you restore, the tool reads a SQLite backup file and writes the data into a fresh MySQL/MariaDB or PostgreSQL database with the correct schema already applied.
Operations
Copy
Copy data from any supported source to any supported target.
Examples:
- SQLite → MySQL/MariaDB
- MySQL/MariaDB → PostgreSQL
- PostgreSQL → SQLite
Backup
Back up from MySQL/MariaDB or PostgreSQL → SQLite.
The output is a single SQLite file you can store as your backup.
Restore
Restore from a SQLite backup → MySQL/MariaDB or PostgreSQL.
The target database should be an empty database with the FileFlows schema already created.