Urgent: Trapped Data - Cannot Migrate SQLite on Raspberry Pi (ARM64)

Questions
1

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.sqlite file is intact. The n8n list:workflow command successfully reads and lists all 25 of my workflows. The export:credentials command 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:database are 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.

2

hello @cschmaltz

Have you tried to reset the admin password?

n8n user-management:reset

3

The solution was to revert to the backup of the SqL light version the database became to corrupt to salvage tried a multitude of options and solutions from 3 different AI chats and all came down to having to revert to the backups. Unfortunately the credentials were lost but at least the workflows were not lost

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.