Backup restore error

I am running PrivacyIdea 3.5.2 on Ubuntu 20.04.1 LTS and i have been testing the backup and restore functionality. I did the backup as root and included the encryption keys.
root@test:~# pi-manage backup create -e
tar: Removing leading /' from member names tar: Removing leading /’ from hard link targets

When i attempt to restore, i get the below error.
root@test:~# pi-manage backup restore filename.tgz
Also restoring encryption key ‘enckey’
Restoring to /etc/privacyidea/pi.cfg with data from /var/lib/privacyidea/backup/dbdump-20210524-0912.sql
Restoring database.
mysql: [ERROR] unknown variable ‘no-tablespaces=True’.

Any idea why the restore is failing? I also tried restarting the services before and after but same result.

This is a known issue that is resolved in the current master and will be shipped with 3.6.

You can simply look into the tgz backup file and restore manually.

1 Like

Thank you, It worked!

1 Like