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
  • Brite
  • 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 - Status | 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 1.7k 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 Do not disturb
      girishG Do not disturb
      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 Do not disturb
            girishG Do not disturb
            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

            Hello! It looks like you're interested in this conversation, but you don't have an account yet.

            Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

            With your input, this post could be even better 💗

            Register Login
            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