Start mariadb in recovery mode - Unraid: official docker container
Updated
•1 min read
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
