Upload cloudron mysqldump from backup

[natzilla]

I have been unable to restore my database after my server lost power unexpectedly.

Using innode 1 (SRV_FORCE_IGNORE_CORRUPT) option up to 6 has been unsuccessful. The service will never start.

I have a recent snapshot of my box.mysqldump from two days ago. How can I upload this to replace the broken database? Side note: I am unable to access any webpage on the server.

[girish]

@natzilla See https://docs.cloudron.io/troubleshooting/#mysql-host

[natzilla]

@girish I get "error 2002 cant connect to local mysql server through socket"

It looks like somehow I am missing /var/run/mysqld/mysqld.sock as well.

[natzilla]

@girish

I ended up rebuilding since I was having so many problems. I have it recovered now, and I know for the future not to use xfs if I don't have a UPS.

[girish]

@natzilla Ah ok, I think I will improve the docs to say how to exactly recover if mysql is not even running. The troubleshooting guide assumes mysql is running but corrupt.