Hello, this is the second time this has happened to me, but my n8n on my Digital Ocean server no longer works. I don’t have much hope of restarting my application correctly but I would have liked to recover my worflow but I have the impression that there isn’t any. Could someone tell me where to find it so that I can recover as much as possible?
You should have a file called database.sqlite somewhere as long as you mapped /home/node/.n8n in Docker, e.g. - ./n8n_home:/home/node/.n8n. If you didn’t do this, then I think you will lose all the configuration including workflows every time you restart your server or Docker.
Also, you should provide the output of docker-compose logs (run it in the same folder where docker-compose.yml file is located).
I think you can just restart n8n server (at the same version you had it running before, ideally), maybe you need to get a server with more RAM if you have such a big database. My database is just below 10MB.
You can try these to see what’s inside your DB:
$ sqlite3 database.sqlite
sqlite> .mode line
sqlite> select name, nodes, connections from workflow_entity limit 3;
This will show nodes and their connections (for 3 workflows). That’s the structure of a workflow as I understand it: