homarr.db
I've upgraded Homarr to v1.45.0. I can't see homarr.db anywhere and I'm unsure where to go next. Thoughts?
Running Homarr as a Docker container
Windows 11 OS
Compose:
services:
homarr:
container_name: homarr
image: ghcr.io/homarr-labs/homarr:latest
restart: unless-stopped
ports:
- "7575:7575"
volumes:
- ./data:/app/data
environment:
- NODE_ENV=production
- SECRET_ENCRYPTION_KEY= ..........
homarr_backup_watcher:
container_name: homarr_backup_watcher
build: .
restart: unless-stopped
depends_on:
- homarr
volumes:
- ./backup_loop.sh:/app/backup_loop.sh
# Optional if you want the watcher to see homarr.db
# - ./data:/app/data
command: sh /app/backup_loop.sh
Solution:Jump to solution
Resolved
Compose file in Documentation works
C:\ ................. \Homarr\db\db.sqlite NOT homarr.db...
21 Replies
Thank you for submitting a support request.
Depending on the volume of requests, our team should get in contact with you shortly.
⚠️ Please include the following details in your post or we may reject your request without further comment: - Log (See https://homarr.dev/docs/community/faq#how-do-i-open-the-console--log) - Operating system (Unraid, TrueNAS, Ubuntu, ...) - Exact Homarr version (eg. 0.15.0, not latest) - Configuration (eg. docker-compose, screenshot or similar. Use ``your-text`` to format) - Other relevant information (eg. your devices, your browser, ...)
Frequently Asked Questions | Homarr documentation
Can I install Homarr on a Raspberry Pi?
GitHub
homarr/Dockerfile at dev · homarr-labs/homarr
A modern and easy to use dashboard. 30+ integrations. 10K+ icons built in. Authentication out of the box. No YAML, drag and drop configuration. - homarr-labs/homarr
You're looking for the wrong file
Is this true for v1.45.0? I keep reading this:
Homarr does NOT use db.sqlite anymore
It uses homarr.db, and its location depends entirely on how you mounted the volume in Docker.
Where did you read that?
The name can be customised and the path can be customised too. See environment variables
You mean the name of the container, right?
The path doesn't seem to be the issue. It's that I am unable to find/see the .db file for Homarr
I want to ensure that it backups (I'm making scheduled backups) before I continue any further building the Board
Can you please post your entire docker compose as a mardown code block? Your previous one is misformatted
And is this a new installation or did you upgrade?
Sure
services:
homarr:
container_name: homarr
image: ghcr.io/homarr-labs/homarr:latest
restart: unless-stopped
ports:
- "7575:7575"
volumes:
- ./data:/app/data
environment:
- NODE_ENV=production
- SECRET_ENCRYPTION_KEY= ..........
homarr_backup_watcher:
container_name: homarr_backup_watcher
build: .
restart: unless-stopped
depends_on:
- homarr
volumes:
- ./backup_loop.sh:/app/backup_loop.sh
# Optional if you want the watcher to see homarr.db
# - ./data:/app/data
command: sh /app/backup_loop.sh
Upgrade
What is this backup_loop script supposed to do? That is not from Homarr
Also, you're missing the mounting paths. This means your data is in an anonymous volume.
That will be an issue because if you destroy the container, you're data is permanently gone
This is described in our documentation that you should mount it to a directory or a named volume. Please recover your data from the anonymous volume, back it up and then follow the instructions on our documentation.
I mean I did upgrade but lost the Board I'd made so had to start from scratch again
I mean I'm happy to start from scratch again but want to ensure that the Compose file is correct
The script was set to do scheduled backups
You lost the board because the container is not persisting the data (files)
Yep
If you want to fix it without keeping any data and deleting your Homarr data (boards, users, ...) permanently, you can simply change the mounting paths like they are documented here:
https://homarr.dev/docs/getting-started/installation/docker#docker-compose
Docker | Homarr documentation
Docker is our recommended installation method for beginners and professionals.
volumes:
- ./data:/app/data
should be
volumes:
- /var/run/docker.sock:/var/run/docker.sock # Optional, only if you want docker integration
- ./homarr/appdata:/appdata
Yes, the docker.sock is optional if you want to use the Docker integration
Left side of the mount can be changed to an absolute path or leave it as a relative path (but be aware of the trade offs)
Left side of the mount can be changed to an absolute path or leave it as a relative path (but be aware of the trade offs)
*** Sorry, I'm unsure what this means exactly
If you have ./homarr/appdata, it will use the relative path from where you start the compose stack from. To avoid this, use an absolute path (e.g. /mnt/ssd/homarr/appdata)
Please read the Docker documentation and how Docker volumes work. This is not unique to Homarr.
Yep ok.
I'll sort the Compose out and get things back on track.
Thanks!
You're welcome
Can you report back so I can mark this as resolved once you fixed it?
Yep sure np 👍
Solution
Resolved
Compose file in Documentation works
C:\ ................. \Homarr\db\db.sqlite NOT homarr.db
Thanks