Issue Could not start MySQL database

[Liew CheonFong]

I tried to restore a backup from remote storage (S3) then it filled up the server disk space and server crash. I removed plesk temporary files and restart the server. but the mysql database server refuse to start anymore. I can only start the mysql server using "innodb_force_recovery".

May 27 18:59:20 hosting.com systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT​

Help please?

 

[Liew CheonFong]

Recover the database following this article:

How to fix InnoDB corruption cases for the MySQL databases on Plesk for Linux?