I moved the server and signed up on this mail again, I got a problem about my workflow that I made on the old server and did not come in on my new server.
How to solve this problem?
Hey Artcu,
In n8n stores workflow, credential, execution details & other data in SQLite (PostgreSQL in Queue mode). If you change the n8n server, your data lose and want to sign up again because you change server and not mount old data.
Solution:
If you host n8n with Docker you can backup n8n Docker Volume and mount this backup Docker Volume to new one and your old data comes.
I use cloudflre and did not used docker have another way?
If you use Cloudflare, first you want to find database.sqlite file and Compress and send to Other server and map with new one.
Solution:
Step 1: Old n8n Server
sudo tar -czf n8n-transfer-backup.tar.gz -C /your-sqlite-database-path
scp n8n-transfer-backup.tar.gz root@destination-vps-ip:~/n8n-transfer-backup.tar.gz
Step 2: New n8n Server
- We receive tar.gz file from Old n8n server
First delete database.sqlite file
sudo tar -xzf n8n-backup.tar.gz -C /your-new-sqlite-databse-path
1 Like