extract mbstream backup using mariadb's mbstream utility + restore database files

mbstrem-extract-maribackup-restore

# use integrated docker terminal or run bash like this:
docker exec -it CONTAINERID /bin/bash

# unzip and then use mbstream utility to extract data
cd /var/www/html/dbbackup/;
gunzip -c DB.gz | mbstream -x;

# restore db
cd /var/lib/mysql;
rm -r *;
mariabackup --prepare --target-dir=/var/www/html/dbbackup;
mariabackup --copy-back --target-dir=/var/www/html/dbbackup;
chown -R mysql:mysql /var/lib/mysql/;

# (restart docker container)

# login as root to mysql
# then allow login from everywhere
GRANT ALL ON *.* to UZIVATEL@'%' IDENTIFIED BY 'HESLO'; 

https://mariadb.com/kb/en/full-backup-and-restore-with-mariabackup/

https://skoula.cz/blog/2023/08/how-to-restore-mariadb-backup/