Recover workflow from old sqlite

Questions
1

old selfhosted n8n
ubuntu 18

can i recover workflow from sqlite database? i see all data in nodes field.

it starts with

[{"parameters":{},"id":"2e50f7bc-e795-4b7d-9c72-c52c0a142167","name":"Start","type":"n8n-nodes-base.start","typeVersion":1,"position":[-520,120]},{"p
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
4

Hi @Edmunds_Priede

You should be able to extract the workflow json simply by copy-pasting it.
But you can also spin up a local version of n8n and move the database to your n8n directory (.n8n/) or use the env option to set the home path to where the database is.

You could then use the CLI to export your workflows.