Migrate v10 Globodox MySQL DB

Migrate v10 Globodox MySQL DB

Step 1:

Backup DB on old machine


Follow instructions from the link below to take a backup of the MySQL DB...

https://www.globodox.com/support/help/index.htm?backup_a_mysql_based_db.htm


Note:
Make sure you take a backup of all the DBs.
Make sure you backup the multi-user.gdx file. (This file is usually located in the 'C:\ProgramData\ITAZ\Globodox' folder)          
Move the contents to the new machine.

Step 2:

Backup File Store

Note: If your File store is on a Shared drive or on a NAS, and you do not want to move the File store then you can skip this step.

All documents added to GLOBODOX are added to a Windows folder known as the GLOBODOX File Store.  The File Store is the usually the 'C:\Globodox databases\MainDB\Default File Store' folder. 

To know the location of the File Store for your GLOBODOX installation....
  • Start GLOBODOX.
  • Click on Settings. 
  • Click on the 'File Stores' node in the left pane. A list of File stores will be displayed on the right.
  • The 'Folder Path' column will display the location of the File Store.
We would recommend you to manually zip and make a copy of the 'C:\Globodox databases'  folder. Please copy the zip file from the old machine to the same folder location on the new machine. Makes sure you share this folder


Step 3:

Install MySQL

On the new machine, install MySQL and the related ODBC driver.



Step 4:

Restore DB on the new machine.

Follow instructions from the link below to restore the backup of the MySQL DB...



Step 5:

Install Globodox

Install Globodox (the same version as installed on the old machine)
Start Globodox once.
Close Globodox.

Replace the backed up multi-user.gdx file in the 'C:\ProgramData\ITAZ\Globodox' folder.

Step 6:

Pointing Globodox to the new MySQL installation.

  1. Open the Command Line Window.
  2. In the Command Line window type the following at the cursor.
     
    "C:\Program Files\Globodox Desktop\Globodox.exe" /reconfiguremaindb

  3. Now, hit the Enter key.
  4. Globodox will now launch. The MysQL DB Details window will be launched.
  5. Enter the MySQL details for the new machine.
  6. After this is configured, you will get a message confirming that Command Line action has been completed. Globodox will now close.
  7. Start Globodox. The Main DB will now be opened
      If you have more DBs (other than the Main DB) then follow the steps below...
  1. Select Settings > System Settings > DB List in the Navigation pane.
  2. Double click a DB from the list to specify its new location. Click the [...] button. The DB Details window will now be launched.
  3. Specify the details to connect to the the DB located on the new MySQL Server.
  4. Click the Save and close button to save the changes.

Step 7:

Apply Registration Key.

  1. Click on the Globodox button (The round button on the top left)
  2. Click About.
  3. Click the Register button.
  4. Browse to the v10 Registeration key file. (.gxlc2 extension)
  5. Restart Globodox.

Step 8:

Make DB multi-user

  1. Click On Setting>>DB List.
  2. Select each DB and click on the 'Multi-user' button on the Ribbon bar.

Step 9:

Point Client machines to the new server machine.

  1. On each Client machine, launch the Globodox Login Manager.
  2. Specify the Server URL of the new machine.
  3. Click Test Connection.
  4. Click OK.
Step 10:

Confirmation

Turn off the old machine to confirm everything is fine.
If you cannot turn off the old machine , shut down the MySQL Service and the Globodox Server Service on the old machine.

    • Related Articles

    • Migrate Globodox v10 MSSQL DB

      Step 1: Backup DB on old machine Follow instructions from the link below to take a backup of the MSSQL DB... https://www.globodox.com/support/help/index.htm?backup_a_ms_sql_db_main.htm Note: Make sure you take a backup of all the DBs. Make sure you ...
    • MySQL: 002 : Repair corrupted MySQL DB

      Repairing a MySQL DB from Windows Command Line Step 1: Open the Windows Command Line - Go to Start >> and Search for 'cmd'. Click on 'Command Prompt' once the Search results show up. You can alternatively type in (Windows + R) to open the Run Dialog ...
    • ODBC drivers for MySQL based DB

      If you are using GLOBODOX v9 or below... Please download the ODBC connector for MySQL from the link below... https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-5.1.4-win32.msi Run the msi file on all the machines on which ...
    • Find if your GLOBODOX DB is MS Access based, MySQL Server based or MS SQL Server based

      Start GLOBODOX and go to Settings Click on DB List under System Settings Under the column name Type, you will find the type of DB (please refer to the screenshot below) That's it!
    • MySQL: 001 : Unknown MySQL server host 'Server_Name'

      Causes :  The error indicates that the logged in Windows user does not have permission to connect to MySQL. This could be due to restricted or limited access on MySQL. Solution : You will have to provide permissions for the MySQL root user, as this ...