Start mariadb in recovery mode - Unraid: official docker container

mysql recovery mode

ssh into unraid

cd /mnt/user/appdata/mariadb-official/config

nano my.cnf

paste in

[mysqld]
innodb_force_recovery=1

exit

chmod 0444 my.cnf

restart the docker container.

Fix whatever broke

specifically, I broke a table in my nextcloud database

in the unraid ssh session, attach to the mariadb container

docker exec -it MariaDB-Official /bin/bash

mysqlcheck is a feature built into mariadb, and is a lot faster

mysqlcheck -u nextcloud -p --auto-repair --check --all-databases

delete the my.cnf file

done :)