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

    Database Import

    Scheduled Pinned Locked Moved
    FOG Problems
    3
    5
    2.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.
    • T
      TylerC
      last edited by

      I just did a FOG fresh install because I was having issues. Actually reinstalled Ubuntu and everything. I did a backup of the database from the GUI when going into the new FOG server and trying to reimport the database it doesn’t do anything. I click import and the screen reloads with saving FOG configuration and that’s it not completed or anything and none of the hosts are showing up. Any suggestions?

      1 Reply Last reply Reply Quote 0
      • T
        TylerC
        last edited by

        I’ve tried doing a manual import as well and I get the error message ERROR 1064 (42000) at line 1449: 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 ‘27157550’ at line 1

        Any idea what this means?

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

          I just ran into the same issue… did you happen to figure out what the solution is?

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

            FYI here is my solution…

            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… there were others

            1 Reply Last reply Reply Quote 0
            • A
              axel12
              last edited by

              I would recommend to install PHPmyadmin
              [url]http://www.phpmyadmin.net/home_page/index.php[/url]

              You can easily administer your fog database … insert things manually, remove or add columns … you know - all that “admin-y” stuff that lets you break the whole thing if you are not careful. but at least you do not need to know any SQL … and can monitor the back-end directly.

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

              151

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project