How to test your Mariadb backup with Docker

An easy way to test your backup is creating a new instance :

docker run -d --rm --name mariadb-test --env MARIADB_ROOT_PASSWORD=root-pw \ 

 --env MARIADB_USER=user1 --env MARIADB_PASSWORD=passwd1 -p 3306:3306 mariadb

Restore your backup:

docker exec -i mariadb-test mariadb --password=root-pw -uroot  < backup_yyyymmdd.sql

Grant access to the user on your databases:

docker exec -it mariadb-test mariadb --password=root-pw -uroot

GRANT ALL PRIVILEGES ON *.* to 'user1'@localhost IDENTIFIED by 'passwd1';
flush privileges;

You should now connect as previously:

docker exec -it mariadb-test mariadb --password=passwd1 -uuser1