Body:
Hello,
I have an n8n instance that I can no longer log into, and I’m trying to migrate my data to a new PostgreSQL setup, but I am completely stuck. My data is trapped.
My Environment:
-
n8n Version: 1.109.2 (and have tried 1.112.6)
-
Database: SQLite
-
Host: Raspberry Pi (ARM64 architecture)
-
Setup: Self-hosted via Docker
The Goal:
- Recover 25 workflows and ~50 credentials and migrate to a new PostgreSQL instance.
The Core Problem: The export:workflow and export:credentials CLI commands are not working correctly. They can read the data from the database.sqlite file, but they fail silently to write any files to disk.
What We Have Proven:
-
My
database.sqlitefile is intact. Then8n list:workflowcommand successfully reads and lists all 25 of my workflows. Theexport:credentialscommand successfully reads and prints the credential JSON to the console. -
The problem is not host permissions. We have manually created the target directories and set permissions to
777, and the commands still fail to write any files. -
Upgrading is not an option. We have confirmed by checking Docker Hub that there are no official n8n v2+ Docker images for the ARM64 architecture. This means modern tools like
export:databaseare unavailable.
My Question: Given that the standard CLI export tools are failing to write files on ARM64, how can I manually extract my workflow and credential data from the database.sqlite file in a format that can be restored into a new, clean n8n instance?
I am at a complete standstill and risk losing months of work. Any help would be greatly appreciated.