Can I restore data form a sqlite database?

Questions
1

I had an n8n self hosted instance deployed by easypanel.

That old instance stoped working and I installed another instance, I backuped the database.sqlite and tried to replace the new database with the old one, but it didn’t worked. Maybe related to encription or databse structure.

Is there any method to restore the workflows that I have in the old database?
I think that “workflow_entity” table has non-encrypted data. Can I migrate that info with a tool or manually?
I also looked at “credentials_entity” but it seems that this table has encrypted data.

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:
3

Welcome to the community @Santi_V !

Tip for sharing information

Pasting your n8n workflow

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

That implies to any JSON output you would like to share with us.

Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!

Yes, workflow_entity contains the workflows’ parts, which you would have to assemble to produce the actual workflow configuration. That is, the table contains the fields such as nodes, connectios, meta, etc. The actual workflow configuration has the structure

{
  "name": "...",
  "nodes": [...],
  "pinData": {},
  "connections": {...},
  "active": false,
  "settings": {...},
  "versionId": "...",
  "meta": {...},
  "id": "...",
  "tags": []
}

You just need to compose all the values from the table’s columns rebuilding the whole workflow structure to be usable in canvas or via import.

Perhaps, you can try to clone this table specifically in your new instance database to avoid manually assembling the workflows and pasting them into canvas or via file import.