DB Migration from Windows to Linux


This document will explain the steps required in order to migrate a Windows installation of netLD to a Linux server.


Overview

To migrate from windows to linux, netLD uses the same steps as would be used to restore a system backup of netLD on the same system. Running a “System Backup” in netLD creates snapshot of the netLD database. The snapshot is sufficient to be used to restore all the data from one netLD installation into another.


The basic steps to do the migration are fairly simple…

  1. Upgrade netLD on windows to the most recent version.
  2. Take a system backup of netLD in Windows.
  3. Install the same, most recent version of netLD on the target Linux system.
  4. Restore the system backup taken on the Windows installation into the new Linux install


1. Upgrade netLD on Windows

System Backups in netLD are only valid for the same revision of the netLD software. This means that when migrating from one system to another, you need to be sure that both systems are on the exact same netLD revision. So before doing anything else, first you must upgrade the existing windows installation of netLD. 


Online Update

For netLD servers with access to the Internet you can update to the latest version simply by using the Software Update feature in the netLD UI.

  1. Login to the netLD user interface using an Administrator user (e.g.: admin)
  2. Go to the Server Settings dialog by clicking the Settings button in the upper right hand corner of the screen.
  3. Select the Software Update page
  4. If the page says, “The software is up to date”, click the Check for Updates button.
  5. If an update is available click the Install Update button.
  6. The update will be installed, and the server will restart.


Offline Update

For netLD servers without access to the Internet you can update to the latest version by running the latest version of the installer again on the Windows server. 


2. Take System Backup of netLD on Windows

  1. Login to the netLD user interface using an Administrator user (e.g.: admin)
  2. Go to the Server Settings dialog by clicking the Settings button in the upper right hand corner of the screen.
  3. Select the System Backup page
  4. Click the Perform System Backup Now button
  5. A backup folder named like backup_YYYY-MM-DD will be created in C:\Program Files\Net LineDancer\backups


The system backup folder will be of the form backup_YYYY-MM-DD. This folder contains a snapshot of both the derby database as well as the lucene search index folder.


3. Install netLD on Linux

Now we will install the latest version of netLD on the target Linux system. The steps to install this netLD are the same as installing any new copy of netLD.


Once the installation completes you will need to log in to the new installation once to activate it. Since netLD licenses are tied to individual MAC addresses, a new license may be required.


4. Restore System Backup into new Linux installation

The final step to migrate from Windows to Linux is to copy the system backup taken in step 1 into the new Linux installation.

  1. Stop the netLD service on the linux server using the following command…
    1. service netld stop
  2. Copy the two folders, derby and lucene, taken in the backup in step 1 into /usr/share/netld on the new system. This will overwrite the derby and lucene folders that were created for the new installation.
  3. Reapply the correct ownership to all files in the netld folder. To do this, run the following command as root…
    1. chown -R netld:netld /usr/share/netld
  4. Restart the netLD service on the linux server
    1. service netld start
  5. Login to the new Linux netLD install using the web interface and confirm that the data was correctly migrated.