Database Tool
The FileFlows Database Tool is a standalone utility for copying, backing up, and restoring your FileFlows database across different database engines.
What It Does
- Copy a database from one 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 Tool 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.