Jump to content
Sign in to follow this  
hoeg

[SOLVED] Need help fixing corrupted Kodi MySQL Database Please!

4 posts in this topic Last Reply

Recommended Posts

Posted (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 by hoeg

Share this post


Link to post
Posted (edited)

When the error happens, the docker stops.  Need to run innodb-force-recovery=1.

Edited by hoeg

Share this post


Link to post
Posted (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 by hoeg

Share this post


Link to post
Posted (edited)

Mysql docker is still running and I am setting up backups for it now.

Edited by hoeg

Share this post


Link to post

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this