• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Jun 17, 2014, 12:40 PM

    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 Jun 17, 2014, 3:04 PM

      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 Sep 19, 2014, 4:11 PM

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

          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 Sep 22, 2014, 5:33 AM

            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

            179

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project