How to Restore LabTech Database

How to Restore LabTech Database

Restore the LabTech Database

Overview

It is essential to your business to have backups of your IT environment. Lost data can cause a noteworthy emergency, lost income and extremely uphappy customers.


Info! This document gives well-ordered instructions to restore your Automate system from backup. We recommend you do not skip any step. If you are feeling uncomfortable performing the restore, do not hesitate to Contact us.


How LabTech does backup of database?

You must be interested to know how LabTech does backup of database.

  1. LabTech create dump of each table and restore into %ProgramFiles%\ LabTech\Backup\TableBase folder.
  2. And then packs all dump files into a zip file called LabTech.1.zip and places it in %ProgramFiles\LabTech\Backup.

Info: LabTech perform backup operation during the 3AM maintenance.


Steps to Restore LabTech from Backup

Prerequisite
  1. Make sure you logged in as Administrator to Connectwise Automate (formerly LabTech) server.
  2. Download: All Batch and Powershell Scripts that are used in this article.
  3. Make sure you have backup file that you want to use for restoring the LabTech.
  4. Make sure you know rootPassword of MySQL.
    • Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\LabTech\Setup registry key and copy the password that given in “ RootPassword ” value.

    Note: You may know the “RootPassword" by using batch script called " KnowYourRootPassword.bat". And, edit the following files and replace the word " ProvideYourPasswordHereWithoutQuotes” with your root password.

    • Drop and Create LabTech Database.bat
    • Import Data to Database.bat
    • Import Structure to Database.bat
    See screenshot.
    batch script root password


  5. Know MySQLEXE file path. There are few steps you need to follow, in order to know MYSQL setup folder.
  6. Note :


    • Know to location of my.ini file. Open the properties of LabMySQL service and look at the path of Path to executable .
    • Open the my.ini file in notepad and find “ basedir ” variable.
    • Open explorer and navigate to value of basedir variable and then open bin folder.
    • There, you can see “mysql.exe” file. Hold shift key and right click on “mysql.exe” file and then click on “Copy as path”.

    Note: You just copied mysql.exe file's full path. Open the following script files in notepad and provide path to "MySQLexe" variable ( without Quotes ).

    • Drop and Create LabTech Database.bat
    • Import Data to Database.bat
    • Import Structure to Database.bat
    See screenshot.
    restore LabTech setup image

  7. Lastly, you need to know where your database is stored.
    • Again, Open my.ini file in notepad and find “ datadir ” variable.
    • Value of datadir variable is your LabTech database folder path.

    Important: :

    • Drop and Create LabTech Database.bat
    • Import Data to Database.bat
    • Import Structure to Database.bat

Stop LabTech Critical services
  1. Stop all the following services.
    • LabMySQL (LabMySQL),
    • LabTech Database Agent (LTAgent),
    • LabTech Monitoring service (LTService) ,
    • LabTech Monitoring Service Checkup Util (LTSvcMon),
    • LabTech Redirector Service (LTRedirSvc).
Use the following Powershell command to stop LabTech critical services

  • Open Windows Powershell and run the following command.
Get-service LabMySQL,LTAgent,LTService,LTSvcMon,LTRedirSvc | ?{$_.status -eq 'running'}|stop-service

Info! Please verify that all above services' status manually by opening services.msc

Unzip LabTech databse "Structure" and "Data" to "Labtech.1" folder on your desktop!
  • Create a New folder on your desktop and rename it LabTech.1
  • Navigate to the C:\Program Files\LabTech\Backup folder
  • And right-click on the most recent backup file, Labtech.1
  • And select ExtractAll zip file's content in recently created folder Desktop\LabTech.1\
  • Now, navigate to the C:\Program Files\LabTech\Setup directory
  • Copy the following files and paste them in C:\Users\Administrator\Desktop\LabTech.1\ folder
  • DBaseTable.sql,
  • DBaseViews.sql ,
  • DBaseTrigger.sql,
  • DBaseProc.sql.
Delete logs files and a folder

Open to C:\Program Files (x86)\LabTech\mysql\data folder and delete the following log files and a folder.

  • labtech (a folder).
  • ibdata1, ib_logfile0 and ib_logfile1 log files.
  • Note: If you don’t find these files and given folder there then check “Program Files” directory.

Re-create LabTech database

Before proceeding further, Please make sure LabMySQL is running. If not, open the command prompt and run the following command.

Download File: Start LabMySQL Service.bat net start LabMySQL

Now, you need to drop "LabTech" database and create it again.Use the following batch script to recreate MySQL database called "LabTech". Replace ProvideYourPasswordHereWithoutQuotes with root password in the following script.

Download File: Drop and Create LabTech Database.bat @echo off SET rootuser=root SET rootPassword=ProvideYourPasswordHereWithoutQuotes SET MySQLexe="c:\program files (x86)\labtech\mysql\bin\mysql.exe" %MySQLexe% --user=%rootuser% --password=%rootPassword% --execute="drop database labtech;" Echo ...................Dropped LabTech Database.................. Echo. pause > nul Echo ...................Creating LabTech Database................... Echo. %MySQLexe% --user=%rootuser% --password=%rootPassword% --execute="create database labtech;" Echo LabTech Database has been created successfully................... echo. pause > nul

Import LabTech database structure

After re-creating database, you need to import MySQL “Tables”, “Views”, “Triggers” and “Procedures” into database. Use the following batch script.

Download File: Import Structure to Database.bat @echo off SET rootuser=root SET rootPassword=ProvideYourPasswordHereWithoutQuotes SET MySQLexe="c:\program files (x86)\labtech\mysql\bin\mysql.exe" SET sourceFolder=%USERPROFILE%\Desktop\Labtech.1 %MySQLexe% --user=%rootuser% --password=%rootPassword% -b labtech < "%sourceFolder%\DBaseTable.sql" echo. Echo ...................Imported LabTech Tables structure.................. Echo. %MySQLexe% --user=%rootuser% --password=%rootPassword% -b labtech < "%sourceFolder%\DBaseViews.sql" echo. Echo ...................Imported LabTech Views.................. Echo. %MySQLexe% --user=%rootuser% --password=%rootPassword% -b labtech < "%sourceFolder%\DBaseTrigger.sql" echo. Echo ...................Imported LabTech Triggers.................. Echo. %MySQLexe% --user=%rootuser% --password=%rootPassword% -b labtech < "%sourceFolder%\DBaseProc.sql" echo. Echo ...................Imported LabTech Procedures.................. Echo. Echo --------------------- Press any key to Exit---------------------- Pause > nul
Import LabTech Database data

Now, we need to import data in LabTech database. Use the following batch script for that.

Download File: Import Data to Database.bat

@echo off SET rootuser=root SET rootPassword=ProvideYourPasswordHereWithoutQuotes SET MySQLexe="c:\program files (x86)\labtech\mysql\bin\mysql.exe" SET sourceFolder=%USERPROFILE%\Desktop\Labtech.1 FOR /f %%a IN ('dir /b %sourceFolder%\*.sql') DO "%MySQLexe% --user=%rootuser% --password=%rootPassword% -b labtech < "%sourceFolder%\%%a" Echo. Echo ...................Imported LabTech data in database.................. Echo --------------------- Press any key to Exit---------------------- pause > nul
Log in to the Control Center

Log in to the Control Center and verify that all agents are there, and then wait approximately 10 minutes for the agents to begin to check in

Overview

It is essential to your business to have backups of your IT environment. Lost data can cause a noteworthy emergency, lost income and extremely uphappy customers.

Info! This document gives well-ordered instructions to restore your Automate system from backup. We recommend you do not skip any step. If you are feeling uncomfortable performing the restore, do not hesitate to Contact us.

How LabTech does backup of database?

You must be interested to know how LabTech does backup of database.

  1. LabTech create dump of each table and restore into %ProgramFiles% LabTechBackupTableBase folder.
  2. And then packs all dump files into a zip file called LabTech.1.zip and places it in %ProgramFilesLabTechBackup.

Info:
LabTech perform backup operation during the 3AM maintenance.

Steps to Restore LabTech from Backup

accordion

Leave a Reply

Your email address will not be published. Required fields are marked *

11 + 7 =