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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. Upload cloudron mysqldump from backup

Upload cloudron mysqldump from backup

Scheduled Pinned Locked Moved Support
troubleshootmysql
5 Posts 2 Posters 760 Views 2 Watching
  • 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 Offline
      N Offline
      natzilla
      wrote on last edited by girish
      #1

      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

      girishG 1 Reply Last reply
      0
      • N 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.

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

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

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

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

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

        N 2 Replies Last reply
        0
        • girishG girish

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

          N Offline
          N Offline
          natzilla
          wrote on last edited by natzilla
          #3

          @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
          0
          • girishG girish

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

            N Offline
            N Offline
            natzilla
            wrote on last edited by
            #4

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

            girishG 1 Reply Last reply
            0
            • N 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.

              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #5

              @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
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • Bookmarks
                • Search