Issue Plesk not Starting (Possible MySql issue)

[Sharky]

Server operating system version

CentOS 7.9.2009 x86_64

Plesk version and microupdate number

Plesk Obsidian 18.0.55.1

Good morning all, never had to use the Forum before so please let me know if i have missed any information
So let me explain my issues, my Plesk Login page is not working, but my website files are online and all work apart from not being able to login to each website i suspect this has got something todo with MySql as when i run "service mysqld restart"

I get this result
"Redirecting to /bin/systemctl restart mysqld.service
Failed to restart mysqld.service: Unit not found."

"plesk repair -y"
Gives me error "DB query failed: SQLSTATE[HY000] [1049] Unknown database 'psa'
exit status 1"


"service mysql stop || service mariadb stop && service plesk-web-socket stop"

"Redirecting to /bin/systemctl stop mysql.service
Failed to stop mysql.service: Unit mysql.service not loaded.
Redirecting to /bin/systemctl stop mariadb.service
Redirecting to /bin/systemctl stop plesk-web-socket.service"

and Main plesk login is giving "

502 Bad Gateway​

"

 

[scsa20]

Have you looked at this article yet by chance? https://support.plesk.com/hc/en-us/...-Unable-to-access-Plesk-Unknown-database-psa-

 

[Sharky]

Have you looked at this article yet by chance? https://support.plesk.com/hc/en-us/...-Unable-to-access-Plesk-Unknown-database-psa-

zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin
Gives me

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

 

[Sharky]

and
plesk repair -y
DB query failed: SQLSTATE[HY000] [2002] No such file or directory

exit status 1
gives that now, all Domain Dumps have been cleared also, very strange and within /var/lib/mysql im missing a fair amount of databases

 

[Peter Debik]

Maybe the disk is faulty?

 

[Sharky]

Maybe the disk is faulty?

Wouldnt this Cause mass slowdown when transfering data?
As i can move stuff/add stuff via FTP and its all good with no speed issues or courrupt files :/