Backup restore don't restore DB

[esturniolo]

Installation Method

Docker Installation

AzuraCast Release Channel

Rolling Release Channel

Current AzuraCast Version

Rolling Release #6f51835 (2024-08-23 4:22)

What happened?

I'm trying to automate the installation process and for this, I need to test the backup recovery. I first created a sample station with some info (including some music) in order to populate the DB. Then I create a backup file (I tried both: manual and automatic wih same results) like this:

I've got the backups inside the container in the common path:

root@9018a487be2a:/var/azuracast/backups# ls -l
total 32
-rw-r--r-- 1 azuracast azuracast 15863 Aug 25 13:55 automatic_backup_20240825_112300.zip
-rw-r--r-- 1 azuracast azuracast 14807 Aug 25 13:32 manual_backup_20240825_1332.zip

Some directories are binded to a external volume in order to keep the music, recordings and backups outside the container:

docker-compose.override.yml content:

services:
  web:
    volumes:
      - /mnt/HC_Volume_101216949/media:/var/azuracast/stations/tofu-radio/media
      - /mnt/HC_Volume_101216949/recordings:/var/azuracast/stations/tofu-radio/recordings
      - /mnt/HC_Volume_101216949/backups:/var/azuracast/backups

Volume mount with bind path:

eas@tofu-radio:/mnt/HC_Volume_101216949$ ll
total 36
drwxr-xr-x 6 eas  eas   4096 Aug 25 09:21 ./
drwxr-xr-x 3 root root  4096 Aug 25 13:45 ../
drwxr-xr-x 2 eas  eas   4096 Aug 25 13:56 backups/
drwx------ 2 eas  eas  16384 Aug 25 09:19 lost+found/
drwxr-xr-x 5 eas  eas   4096 Aug 25 10:04 media/
drwxr-xr-x 2 eas  eas   4096 Aug 25 09:21 recordings/
eas@tofu-radio:/mnt/HC_Volume_101216949$ ll backups/
total 40
drwxr-xr-x 2 eas eas  4096 Aug 25 13:56 ./
drwxr-xr-x 6 eas eas  4096 Aug 25 09:21 ../
-rw-r--r-- 1 eas eas 15863 Aug 25 13:55 automatic_backup_20240825_112300.zip
-rw-r--r-- 1 eas eas 14807 Aug 25 13:32 manual_backup_20240825_1332.zip

All the files inside the container are properly owned by azuracast user/group

Later I recreate the instance and tried to recover the backup like this with almost no output and nothing mentioning the DB migrations or nothing related:

eas@tofu-radio:/var/azuracast$ yes | sudo ./docker.sh restore /mnt/HC_Volume_101216949/backups/manual_backup_20240825_1332.zip
[+] Running 3/3remove any existing AzuraCast installation data, replacing it with your backup. Continue? [Y/n]
 ✔ Container azuracast          Removed                                                                                                                                                                                                                                                                                6.3s
 ✔ Container azuracast_updater  Removed                                                                                                                                                                                                                                                                                0.1s
 ✔ Network azuracast_default    Removed                                                                                                                                                                                                                                                                                0.1s
azuracast_backups
azuracast_db_data
azuracast_sftpgo_data
azuracast_www_uploads
azuracast_backups
Unable to find image 'busybox:latest' locally
latest: Pulling from library/busybox
213a27df5921: Pull complete
Digest: sha256:9ae97d36d26566ff84e8893c64a6dc4fe8ca6d1144bf5b87b2b85a32def253c7
Status: Downloaded newer image for busybox:latest
[+] Creating 4/0
 ✔ Network azuracast_default       Created                                                                                                                                                                                                                                                                             0.1s
 ✔ Volume "azuracast_sftpgo_data"  Created                                                                                                                                                                                                                                                                             0.0s
 ✔ Volume "azuracast_db_data"      Created                                                                                                                                                                                                                                                                             0.0s
 ✔ Volume "azuracast_www_uploads"  Created                                                                                                                                                                                                                                                                             0.0s
the input device is not a TTY
[+] Running 1/0
 ✔ Network azuracast_default  Removed                                                                                                                                                                                                                                                                                  0.1s
[+] Running 3/3
 ✔ Network azuracast_default    Created                                                                                                                                                                                                                                                                                0.1s
 ✔ Container azuracast_updater  Started                                                                                                                                                                                                                                                                                0.3s
 ✔ Container azuracast          Started                                                                                                                                                                                                                                                                                2.8s
eas@tofu-radio:/var/azuracast$

Once the backup is finished I only have a brand new Azuracast instance without any info related saved in the backup.

Even I tried to restore a backup for another test station that's online for more than a month. Same results.

I expected to have the users loaded, the db music in place (remember that the files are mount in an external volume and after some media refresh, the files should be recognized by Azuracast), playlist, broadcasting users, broadcasting mount points and a large list of etc. But nothing.

What am I doing wrong?

Thanks in advance!!!!

Relevant log output

No response