Retrieving workflows from database.sqlite

Questions
1

Describe the problem/error/question

Hello everyone, i hosted n8n on my vpc via docker though cloud flare tunnels, i wanted to change the vpc i was using so i backed up the database.sqlite from /var/lib/docker/volumes/n8n_n8n_data thinking it would just work.
i was wrong, i changed from tunnels to a normal DNS with nginx reverse proxy which worked fine until i changed the database.sqliteto the old one then i wasn;t able to connect to the instance.
so, my question would be can i change some settings in the database to work again? or can i get the workflows back from the database?

Notes:

i noticed there is workflow_entity table including all my workflows but i have no idea how to get the json that i can copy to n8n.

i know that i should’ve taken a backup of each workflow but i forgot.

What is the error message (if any)?

cloudflare error: Bad gateway Error code 502

Information on your n8n setup

  • Database : SQLite
  • Running n8n via : docker
  • Operating system: Ubuntu
2

Hi welcome to n8n community :n8n:

Have you tried using n8n directly via the CLI here: CLI commands | n8n Docs ? In my opinion, the best way to migrate in n8n is simply by importing and exporting the workflows or credentials. The case would be different if you still need the execution logs.