Update manager

[Sebbeben]

I made a update manager for partdb where you can upgrade/downgrade, it makes backups and logs.

#1217

[Maystero14]

Is there a plan for Docker to support backing up just the database (SQL) and attachments (PDFs, JPGs, etc.) in the future?

[Sebbeben]

I've added this functionality in PR #1255. In the latest update:

• Create Backup button is now available for all installation types, including Docker
• Download button on each backup — you can download the ZIP directly from the UI, which is especially useful for Docker since var/backups/ is not a persistent volume
• Restore works for Docker too (database + attachments) when enabled via DISABLE_BACKUP_RESTORE=0 in your environment
• A Docker-specific info banner reminds you to either download backups or mount var/backups/ as a volume

[Maystero14]

Thanks for the reply, Sebastian. You’ve done a solid piece of work here! However, I think something might be messed up on my end, or there’s a problem I’m just not seeing.

Below is my YAML (from QNAP Container Station):

`
version: '3.8'
services:
partdb_test:
container_name: partdb_test
# By default Part-DB will be running under Port 8080, you can change it here
ports:
- '8080:80'
networks:
part-db-network-test:
ipv4_address: 192.168.88.85
volumes:
# By default
- uploads:/var/www/html/uploads
- public_media:/var/www/html/public/media
- db:/var/www/html/var/db
- html:/var/www/html
restart: unless-stopped
image: jbtronics/part-db1:v2.7.1
depends_on:
- database-test
environment:
# Replace SECRET_USER_PASSWORD with the value of MYSQL_PASSWORD from below
- DATABASE_URL=mysql://partdb:partdb@database-test:3306/partdb
# In docker env logs will be redirected to stderr
- APP_ENV=docker
#hasło do bazy danych, dla konta admin
- INITIAL_ADMIN_PW=***********

  # See .env file for all available options or https://docs.part-db.de/configuration.html

  # The language to use serverwide as default (en, de, ru, etc.)
  #- DEFAULT_LANG=pl
  # The default timezone to use serverwide (e.g. Europe/Berlin)
  #- DEFAULT_TIMEZONE=Europe/Warsaw
  # The currency that is used inside the DB (and is assumed when no currency is set). This can not be changed later, so be sure to set it the currency used in your country
  #- BASE_CURRENCY=PLN
  # The name of this installation. This will be shown as title in the browser and in the header of the website
  #- INSTANCE_NAME=Part-DB

  # Allow users to download attachments to the server by providing an URL
  # This could be a potential security issue, as the user can retrieve any file the server has access to (via internet)
  #- ALLOW_ATTACHMENT_DOWNLOADS=0
  # Use gravatars for user avatars, when user has no own avatar defined
  #- USE_GRAVATAR=0
  #automatically apply database
  - DISABLE_BACKUP_RESTORE=0
  - DB_AUTOMIGRATE=True

  # Override value if you want to show to show a given text on homepage.
  # When this is empty the content of config/banner.md is used as banner
  #- BANNER=This is a test banner<br>with a line break
  #- BANNER=<a href="parts?part_filter[favorite][value]=true">Favorite</a>

  #- PROVIDER_TME_KEY=f7720275aa609e8974e495c91fdef4804724bc8f02059cfadc
  #- PROVIDER_TME_SECRET=d51e6c3f728840ef84f9
  #- PROVIDER_TME_GET_GROSS_PRICES=0

database-test:
container_name: partdb_database-test
image: mysql:8.0
networks:
part-db-network-test:
ipv4_address: 192.168.88.86
restart: unless-stopped
command: --default-authentication-plugin=mysql_native_password --log-bin-trust-function-creators=1
environment:
# Change this Password
MYSQL_ROOT_PASSWORD: partdb
MYSQL_DATABASE: partdb
MYSQL_USER: partdb
MYSQL_PASSWORD: partdb
# Uncomment the following line if you need to access, your MySQL database from outside of docker (e.g. for debugging), normally you should leave that disabled
#ports:
# - '4306:3306'
volumes:
- mysql:/var/lib/mysql

phpmyadmin-test:
image: phpmyadmin:latest
container_name: phpmyadmin-test
restart: always
networks:
part-db-network-test:
ipv4_address: 192.168.88.91
ports:
- 8080:8080
environment:
- PMA_ARBITRARY=1
depends_on:
- database-test

volumes:
uploads:
public_media:
db:
mysql:
html:

networks:
part-db-network-test:
driver_opts:
iface: eth0
driver: qnet
ipam:
driver: qnet
options:
iface: eth0
config:
- subnet: 192.168.88.0/24
gateway: 192.168.88.1
`

As you can see, I have the following entry:

- DISABLE_BACKUP_RESTORE=0

Despite having this environment variable set, the "Create Backup" button is still missing.

Could you help me out with this? Let me know if you need anything else from my side to help track down the cause of the issue.
look na the a short video:

partdb.mp4

[Sebbeben]

Hi @Maystero14, thanks for the detailed report!

The reason you're not seeing the "Create Backup" button is that this PR (#1255) hasn't been merged and released yet - you're running v2.7.1 which is the current stable release.

In the current version, the backup functionality is tied to the auto-update feature, which is disabled for Docker installations. This PR decouples backup creation from auto-update, so Docker users will be able to create and download backups through the UI.

Once this PR is merged and included in a future release, you should see the backup button appear. The DISABLE_BACKUP_RESTORE=0 setting you have is correct - that controls whether restoring backups is allowed, but in the current release the button to create backups doesn't show up for Docker at all.

So everything looks fine on your end - you just need to wait for a release that includes this PR.

[Maystero14]

Thanks for the clarification! I'll wait for the next release then. Glad to hear my YAML config is correct

[Maystero14]

Hi Sebbeben. Are is implemented this option at version Part-DB 2.8.0?

[Sebbeben]

Hi @Maystero14, unfortunately this PR hasn't been merged into v2.8.0 yet. It's been rebased and updated to work with v2.8.0, and all tests are passing, but the decision to merge it is up to @jbtronics as the project maintainer. Hopefully it will be included in the next release!

[Maystero14]

Thanks for the information! Fingers crossed that @jbtronics will merge it soon.