• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Downgraded Ubuntu 14.04 to 13.10(new install) and failed restore fog backup

    Scheduled Pinned Locked Moved
    FOG Problems
    1
    2
    1.3k
    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.
    • G
      GFm
      last edited by

      I decided to downgrade from 14.04 since there were some issues with that still. I decided to go with 13.10 since I know ubuntu a little more than others.

      Anyways, I tried restoring the backup I made in the browser by clicking “import” in fog under “configuration save”. It seems to go through, but nothing shows up. I have restarted too.

      My next test was to manually import the sql file. This is the error I get… Any ideas?

      root@fog:/opt# mysql -D fog -u root -p < fog.sql
      Enter password:
      ERROR 1064 (42000) at line 17: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘801’ at line 1
      root@fog:/opt#

      Thanks for the help!

      1 Reply Last reply Reply Quote 0
      • G
        GFm
        last edited by

        Found my problem… loaded up my original 14.04 ubuntu… and found that some of my tables in the fog database were corrupt. I ran the repair on them and that fixed it 🙂

        mysql -u root -p fog
        mysql> REPAIR TABLE userTracking; -----> this is an example of one table messed up

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        144

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project