hoeg Posted June 10, 2019 Share Posted June 10, 2019 (edited) I had a network issue and it seemed to mess up my shared MySQL database for Kodi. I tried phpmyadmin but the MySQL Docker cannot stay running. Edited June 15, 2019 by hoeg Quote Link to comment
hoeg Posted June 12, 2019 Author Share Posted June 12, 2019 (edited) When the error happens, the docker stops. Need to run innodb-force-recovery=1. Edited June 15, 2019 by hoeg Quote Link to comment
hoeg Posted June 15, 2019 Author Share Posted June 15, 2019 (edited) I used the following command to copy my.cnf to the local system: docker container cp [container]:/etc/mysql/my.cnf container-my.cnf then added innodb-force-recovery=1 to the file container-my.cnf using nano and then copied the file back to the docker using this command: docker container cp container-my.cnf [container]:/etc/mysql/my.cnf After restarting the docker it seemed to do something for a little and then stopped again. Started the mysql docker and then it was back to crashing again. Removed the line out of the my.cnf file that i added above using the same steps. The mysql docker started and then did some stuff for a while and is up and running again. Edited June 15, 2019 by hoeg Quote Link to comment
hoeg Posted June 15, 2019 Author Share Posted June 15, 2019 (edited) Mysql docker is still running and I am setting up backups for it now. Edited June 15, 2019 by hoeg Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.