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

DB : convert FOG 1.2.0 to 1.3.0

Scheduled Pinned Locked Moved Solved
General
4
7
3.6k
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.
  • A
    aruhuno
    last edited by Apr 12, 2016, 7:15 AM

    Hello,

    It’s possible to have a tool to convert FOG 1.2.0 database to 1.3.0 (git 7142) ?
    When I’m going to 1.3.0, I’m using a new server and 1.2.0 won’t export data with UI.

    Thanks for the response.

    "Parce que la connaissance appartient à tout le monde", inios.fr

    1 Reply Last reply Reply Quote 0
    • Q
      Quazz Moderator
      last edited by Apr 12, 2016, 8:04 AM

      As far as I know, the database gets updated automatically.

      You may want to take a backup just in case though.

      1 Reply Last reply Reply Quote 0
      • A
        aruhuno
        last edited by aruhuno Apr 12, 2016, 2:16 AM Apr 12, 2016, 8:15 AM

        I know, but my new instance is already installed… Only hosts interested me is why I did not update.
        Another reason is the transition from Debian 7 to 8 .

        "Parce que la connaissance appartient à tout le monde", inios.fr

        W 1 Reply Last reply Apr 12, 2016, 3:46 PM Reply Quote 0
        • W
          Wayne Workman @aruhuno
          last edited by Wayne Workman Apr 12, 2016, 9:50 AM Apr 12, 2016, 3:46 PM

          @aruhuno The GUI of 1.2.0 can export the data, it’s here:
          FOG Configuration -> Configuration Save -> Export

          If that isn’t working for some reason, you can manually export the db. Steps for that are in here:
          https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

          Here are some steps I found that describe exporting a single table:
          https://steveswanson.wordpress.com/2009/04/21/exporting-and-importing-an-individual-mysql-table/

          Exporting and Importing An Individual MySQL Table

          Posted by Steve on April 21, 2009

          In moving databases from development to production it is sometimes necessary to export individual tables so that they can be imported into another database.

          Exporting the Table
          To export the table run the following command from the command line:
          “mysqldump -p – –user=username dbname tableName > tableName.sql”

          This will export the tableName to the file tableName.sql.
          [NOTE: there should be no space between the two dashes, but I have to write it that way so that it display properly].

          Importing the Table
          To import the table run the following command from the command line:
          mysql -u username -p -D dbname < tableName.sql

          The path to the tableName.sql needs to be prepended with the absolute path to that file. At this point the table will be imported into the DB and you are ready to go!

          I ran into this issue when attempting to add new tables to my database. I am unable to run the “LOAD DATA INFILE” command, that I had previously used to populate tables, because Webfaction does not give the permission to run the command. Therefore the simplest solution was to export a table from the MySQL database on my personal machine and then import it to the database on the Webfaction server, using the export/import commands seen above.

          Hope this helps someone out with exporting individual tables and as always if any clarification is needed or I missed something feel free to let me know.

          –Steve

          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
          • S
            Sebastian Roth Moderator
            last edited by Apr 13, 2016, 12:00 AM

            @aruhuno Please read through this as well: https://forums.fogproject.org/topic/6883/migrate-hosts-from-1-2-to-dev-trunk

            Let us know if you see any issues with migrating the database because I am sure more people will run into this and we should provide a solid solution for this (plus wiki entry!)…

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            1 Reply Last reply Reply Quote 0
            • A
              aruhuno
              last edited by aruhuno Apr 13, 2016, 7:59 AM Apr 13, 2016, 9:33 AM

              Thank you guys, here’s the procedure I finally used:

              • export old FOG database (OLD_fog.sql)
              • export new FOG database (NEW_fog.sql)
              • delete all tables in new FOG database
              • import old FOG database
              • upgrade via FOG interface
              • export hosts via UI
              • delete all tables
              • import backup of new FOG database
              • import hosts via UI (no upgrade needed)

              SOLVED ! 🙂

              "Parce que la connaissance appartient à tout le monde", inios.fr

              1 Reply Last reply Reply Quote 1
              • W
                Wayne Workman
                last edited by Apr 13, 2016, 12:39 PM

                It’s great that it’s done, but simply directly updating would work too. Backups are always recommended, but such complex steps are not necessary.

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

                146

                Online

                12.1k

                Users

                17.3k

                Topics

                155.4k

                Posts
                Copyright © 2012-2024 FOG Project