FOG Project

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

    Database Import

    FOG Problems
    3
    5
    2002
    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
      • 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
        • 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
          • 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
            • 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
              • 1 / 1
              • First post
                Last post

              238
              Online

              10.2k
              Users

              16.3k
              Topics

              149.9k
              Posts

              Copyright © 2012-2020 FOG Project