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

Adding FOG database to another FOG database.

Scheduled Pinned Locked Moved
General
3
8
2.5k
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.
  • B
    Benjamin_D
    last edited by Jun 23, 2017, 1:43 PM

    Hello,

    My company is planning on using FOG In such a way that we will start with one normal install backing up some computers, but will eventually switch to one normal install controlling multiple storage nodes that the backup said computers. This will involve effectively wiping the original normal install, and putting a FOG storage install on it. I see that I can copy the database with mysqldump --allow-keywords -x -v fog > fogbackup.sql and backup the images with cp images/* <backup location>, however I have questions about the process of restoring them.

    While I understand that I can import the database to the new normal install of fog by going to “FOG Configuration” -> “Configuration Save” -> “Import”, will this overwrite the existing database, or will it add my imported database to the existing database?

    If it does overwrite the existing database, how do I add my backup to the currently existing database?

    W 1 Reply Last reply Jun 23, 2017, 1:50 PM Reply Quote 0
    • W
      Wayne Workman @Benjamin_D
      last edited by Jun 23, 2017, 1:50 PM

      @Benjamin_D said in Adding FOG database to another FOG database.:

      will this overwrite the existing database, or will it add my imported database to the existing database?
      If it does overwrite the existing database, how do I add my backup to the currently existing database?

      It will overwrite it, but that’s fine. You would import anyway, but afterwards you’d tweak just a few IP & password related settings, those are described at the bottom of this article: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
      Daily Clean Installation Results:
      https://fogtesting.fogproject.us/
      FOG Reporting:
      https://fog-external-reporting-results.fogproject.us/

      1 Reply Last reply Reply Quote 0
      • Q
        Quazz Moderator
        last edited by Jun 23, 2017, 2:45 PM

        I’m not entirely sure what’s going on here.

        As far as I understand you will have:

        Original FOG Server, this will operate normally, will eventually become storage node

        New FOG Server, will manage nodes

        But as far as I understand the new one will only happen when this transition, occurs, yes? If so, overwriting the database is no problem.

        I don’t believe there’s any easy way to ‘add to’ database, given that it tends to require prerequisite knowledge about what’s already in the database and the import. It’s not impossible, but the difficulty and time it would take to get working far surpasses that of entering in the settings again.

        B 1 Reply Last reply Jun 23, 2017, 3:12 PM Reply Quote 0
        • B
          Benjamin_D @Quazz
          last edited by Jun 23, 2017, 3:12 PM

          @Quazz said in Adding FOG database to another FOG database.:

          But as far as I understand the new one will only happen when this transition, occurs, yes? If so, overwriting the database is no problem.

          The issue comes with the fact that there it may end up being the case that there are multiple “old” servers’ databases that are going to need to be put onto the “new” server.

          Q W 2 Replies Last reply Jun 23, 2017, 3:21 PM Reply Quote 0
          • Q
            Quazz Moderator @Benjamin_D
            last edited by Quazz Jun 23, 2017, 9:21 AM Jun 23, 2017, 3:21 PM

            @Benjamin_D It’s probably just easier at that point to just start off with a storage node setup. There are some articles about it on the wiki and we can help you if needed as well of course.

            1 Reply Last reply Reply Quote 1
            • W
              Wayne Workman @Benjamin_D
              last edited by Jun 25, 2017, 2:46 PM

              @Benjamin_D what was the reason for doing this in phases anyway?

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              B 1 Reply Last reply Jun 27, 2017, 1:56 PM Reply Quote 0
              • B
                Benjamin_D @Wayne Workman
                last edited by Jun 27, 2017, 1:56 PM

                @Wayne-Workman

                My boss was getting very worried about the state of some of the sites that were going to be imaged and wanted to setup conventional FOG normal installs at the sites in the meantime until the centralized AWS EC2 FOG server gets up and running.

                However, I have (for the most part, with an issue related to the database in the “Linux Problems” forum) gotten the AWS EC2 instance working.

                So this thread can be closed for now.

                W 1 Reply Last reply Jun 28, 2017, 1:15 PM Reply Quote 0
                • W
                  Wayne Workman @Benjamin_D
                  last edited by Jun 28, 2017, 1:15 PM

                  @Benjamin_D said in Adding FOG database to another FOG database.:

                  the centralized AWS EC2 FOG server gets up and running.

                  You will absolutely want to use certbot to configure https on that machine.

                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                  Daily Clean Installation Results:
                  https://fogtesting.fogproject.us/
                  FOG Reporting:
                  https://fog-external-reporting-results.fogproject.us/

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

                  162

                  Online

                  12.0k

                  Users

                  17.3k

                  Topics

                  155.2k

                  Posts
                  Copyright © 2012-2024 FOG Project