• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Sep 19, 2014, 3:50 PM

    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 Sep 19, 2014, 5:39 PM

      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
      1 / 1
      • First post
        2/2
        Last post

      192

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project