by Widgeteye »Is there any way to repair mysql or am I going to need to reinstall Debian??
Yes there are ways to repair mysql,..
NO , you shouldn't have to reinstall Debian, but that may depend on
other details, that you have not mentioned.
In this recent thread, http://forums.debian.net/viewtopic.php?f=5&t=131842&p=637821&hilit=remove+mysql#p637821
It is discussed on how to remove and purge, MYSQL,...
The details you have not mentioned,...
What version of Debian ?
What version of MYSQL ?
How did you install this "mythtv" ? and where did you get it ?
It is not in the Debian repositories,..https://www.mythtv.org/wiki/Installing_MythTV_on_Debian
This page will describe how to install on Debian, using the package manager. Currently no MythTV-approved repository exists so the packages need to be built from source. This is an easy process using a script that can be checked out from git.
What else have you done to your system, ? These are things
that may determine if you need to reinstall it or not.
Some times just doing a search using the error message is very use full,
example: Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release
This (below ) was the first hit, of manyhttps://support.plesk.com/hc/en-us/articles/213943785-Mysql-shows-warning-Using-unique-option-is-deprecated-and-will-be-removed-in-a-future-release
The solution is shown , in this (above) link,..all you need to do is read it.
So what version of MYSQL ?, is very relevant.
- Code: Select all
[ERROR] Plugin 'InnoDB' init function returned error.
This error is a little more complicated, and not easy for me to explain, but there is some info and details on it in some search results,...
One last example:mysql error Plugin 'InnoDB' init function returned error
There are several good results, but the 2nd hit, goes into a lot on troubleshooting MYSQL, like which logs to look at, etc:https://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/
That should give you enough example on how to look up the info on
the other 2 errors:
- Code: Select all
MYSQL error Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
MYSQL error Unknown/unsupported storage engine: InnoDB
Just copy/paste the messages into a search engine.
Reinstalling Debian will not solve the mysql errors, these can be solved
by configuring your mysql data base correctly.
It can be a rather tedious process, but yes it can be repaired, or configured correctly, if the admin reads and follows instructions carefully.
However, with 'mythtv", being from somewhere, who knows where, and if it was compiled correctly, that is to say there may be other problems
that go beyond just the MYSQL errors.
So any way, hope that helps.