Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Upload cloudron mysqldump from backup

    Support
    troubleshoot mysql
    2
    5
    90
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • N
      natzilla last edited by girish

      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.

      109629fa-63ce-43b9-aa92-5f8bee326df5-image.png

      9b963b5e-3bc0-42de-88d3-7b4e161777cc-image.png

      289ffa0b-3aca-4c0c-aca0-7fb82cf388f4-image.png

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @natzilla last edited by

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

        N 2 Replies Last reply Reply Quote 0
        • N
          natzilla @girish last edited by natzilla

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

          59b8bd08-2f59-4ff1-b234-2b4594b95f15-image.png

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

          1 Reply Last reply Reply Quote 0
          • N
            natzilla @girish last edited by

            @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 1 Reply Last reply Reply Quote 0
            • girish
              girish Staff @natzilla last edited by

              @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.

              1 Reply Last reply Reply Quote 0
              • First post
                Last post
              Powered by NodeBB