The same happened to me.
I restored a user backup from a hestiacp 1.8.11 with mariadb 10.6.18 to a newly installed hestiacp 1.8.12 with mariadb 10.11.6 and all the DBs were empty after the user restore
You have the same issue, MariaDB 10.6.18 has the change applied but MariaDB 10.11.6 doesn’t so the mysql dumps are not compatible. You can use the MariaDB repo instead of the one included in Ubuntu or Debian but I suppose you are using Debian 12 (because of the MariaDB version installed).
If you installed Hestia on Debian 12, check if you already have this repo /etc/apt/sources.list.d/mariadb.list
And will look like this:
#deb [arch=amd64 signed-by=/usr/share/keyrings/mariadb-keyring.gpg] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/debian bookworm main
If that is the case, edit the repo file, remove the comment #, save it, apt update, apt full-upgrade and once done you should be able to restore the users (including the DBs).
1 Like
Yes, is Debian 12 and the mariadb.list line is commented.
I will follow your tips.
Thanks!
1 Like