Upload cloudron mysqldump from backup
-
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 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.
-
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.
-
@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.