@amirb322
I have taken some considerable effort to reproduce your issue and there are multiple explanations for the root cause of the problem.
It is or was not a good idea to use the plesk repair utility, meaning that I hope that we can still solve the issue as best as possible.
With respect to your question
I suggest that you provide the log of /var/mysql/error.log after a restart of mysql (if that is still possible).
There are three types of log entries that are particular of interest:
1 - all notifications with [error] in the log entry line: you can use a grep command to get those log entries, (and)
2 - notifications hinting InnoDB database corruption: use a command like grep -in corruption /var/mysql/error.log > errors.txt and present the text file in this forum, (and)
3 - if mysql is running, notifications of the kind [Warning] InnoDB: Cannot open table mysql/<table name>: use a similar command as mentioned under point 2 and provide the text file in this forum, to allow us to see if and to what extent your MySQL database server is broken or malfunctioning.
Finally, note that I will be writing some explanation and information with respect to the type of MySQL issue that you have, but I first have to find some time for that.
In the meantime, we can surely focus on your particular issue ......
....... hope the above helps a bit.
Kind regards!
I have taken some considerable effort to reproduce your issue and there are multiple explanations for the root cause of the problem.
It is or was not a good idea to use the plesk repair utility, meaning that I hope that we can still solve the issue as best as possible.
With respect to your question
what is the "adequate" information?
I suggest that you provide the log of /var/mysql/error.log after a restart of mysql (if that is still possible).
There are three types of log entries that are particular of interest:
1 - all notifications with [error] in the log entry line: you can use a grep command to get those log entries, (and)
2 - notifications hinting InnoDB database corruption: use a command like grep -in corruption /var/mysql/error.log > errors.txt and present the text file in this forum, (and)
3 - if mysql is running, notifications of the kind [Warning] InnoDB: Cannot open table mysql/<table name>: use a similar command as mentioned under point 2 and provide the text file in this forum, to allow us to see if and to what extent your MySQL database server is broken or malfunctioning.
Finally, note that I will be writing some explanation and information with respect to the type of MySQL issue that you have, but I first have to find some time for that.
In the meantime, we can surely focus on your particular issue ......
....... hope the above helps a bit.
Kind regards!