Windows Server

15min
Note to self:
If a replication suite is used, please contact Passwork technical support for correct updating and saving of data;
If Passwork is installed on a virtual server, we also recommend creating a virtual snapshot of the operating system state before performing the upgrade.
Preparing and removing an outdated version
Creating a backup
By default MongoDB administration utilities are not located in the $PATH environment variable, to use it you need to search for utilities using PowerShell.
Open PowerShell as — "Administrator":
Right-click on the "Start" icon in the lower left corner of the screen;
Select "Windows PowerShell (Administrator)" from the context menu.
Perform a search for administration utilities:
PowerShell
$utilityPath = Get-ChildItem -Path "C:\" -Filter "mongodump.exe" -Recurse -ErrorAction SilentlyContinue | Select-Object -First 1; $utilityDirectory = $utilityPath.DirectoryName; cd $utilityDirectory
$utilityPath = Get-ChildItem -Path "C:\" -Filter "mongodump.exe" -Recurse -ErrorAction SilentlyContinue | Select-Object -First 1; $utilityDirectory = $utilityPath.DirectoryName; cd $utilityDirectory
﻿
If MongoDB and the administration utilities were installed on a non-standard drive, you need to change the search path in the -Path parameter
Once executed, the current working directory will be changed to the one in which the utilities are located, to test execute:
PowerShell
dir
dir
﻿
Create directory:
PowerShell
mkdir C:\backup\
mkdir C:\backup\
﻿
Create a backup:
PowerShell
$timestamp = Get-Date -Format "yyyy-MM-dd_HH-mm"
.\mongodump --out "C:\backup\mongo-$timestamp"
$timestamp = Get-Date -Format "yyyy-MM-dd_HH-mm"
.\mongodump --out "C:\backup\mongo-$timestamp"
﻿
The mongodump and mongorestore utilities are located in the same MongoDB 4.x installation directory.
Removing
Stop the service:
PowerShell
net stop MongoDB
net stop MongoDB
﻿
Delete database:
PowerShell
sc.exe delete "MongoDB"
sc.exe delete "MongoDB"
﻿
Delete the directory with the contents of the database:
PowerShell
if (Test-Path "$env:ProgramFiles\MongoDB") {
    Remove-Item -Path "$env:ProgramFiles\MongoDB" -Recurse -Force
    Write-Host "MongoDB directory has been deleted." -ForegroundColor Green
} else {
    Write-Host "MongoDB directory not found."
}
if (Test-Path "$env:ProgramFiles\MongoDB") {
    Remove-Item -Path "$env:ProgramFiles\MongoDB" -Recurse -Force
    Write-Host "MongoDB directory has been deleted." -ForegroundColor Green
} else {
    Write-Host "MongoDB directory not found."
}
﻿
Perform a search for MongoDB in the registry:
PowerShell
$mongo = Get-ChildItem -Path "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" | Where-Object {
    ($_ | Get-ItemProperty).DisplayName -like "*MongoDB*"
}
$mongo = Get-ChildItem -Path "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" | Where-Object {
    ($_ | Get-ItemProperty).DisplayName -like "*MongoDB*"
}
﻿
Delete an entry from the registry:
PowerShell
if ($mongo) {
    $mongo.PSPath | Remove-Item -Recurse -Force
    Write-Host "Record removed from the registry" -ForegroundColor Green
} else {
    Write-Host "Record with DisplayName not found"
}
if ($mongo) {
    $mongo.PSPath | Remove-Item -Recurse -Force
    Write-Host "Record removed from the registry" -ForegroundColor Green
} else {
    Write-Host "Record with DisplayName not found"
}
﻿
Installing and restoring a backup
Installation
Download MongoDB installer:
PowerShell
try {
    (New-Object System.Net.WebClient).DownloadFile("https://repos.passwork.pro/repository/windows_packages/mongodb_database_latest.msi", "$env:SystemDrive\Windows\Temp\mongodb_database_latest.msi")
    Write-Host "MongoDB successfully uploaded" -ForegroundColor Green
} catch {
    Write-Host "Error loading MongoDB: $_" -ForegroundColor Red
}
try {
    (New-Object System.Net.WebClient).DownloadFile("https://repos.passwork.pro/repository/windows_packages/mongodb_database_latest.msi", "$env:SystemDrive\Windows\Temp\mongodb_database_latest.msi")
    Write-Host "MongoDB successfully uploaded" -ForegroundColor Green
} catch {
    Write-Host "Error loading MongoDB: $_" -ForegroundColor Red
}
﻿
In case of an error, you can download the installer manually — https://repos.passwork.pro/repository/windows_packages/mongodb_database_latest.msi﻿
Install MongoDB by default:
PowerShell
try {
    Start-Process -FilePath "msiexec.exe" -ArgumentList "/l*v", "$env:SystemDrive\Windows\Temp\mdbinstall.log", "/qb", "/i", "$env:SystemDrive\Windows\Temp\mongodb_database_latest.msi", "SHOULD_INSTALL_COMPASS=0", "ADDLOCAL=Router,ServerService" -Wait -ErrorAction Stop
} catch {
    Write-Host "Error installing MongoDB: $_." -ForegroundColor Red
}
try {
    Start-Process -FilePath "msiexec.exe" -ArgumentList "/l*v", "$env:SystemDrive\Windows\Temp\mdbinstall.log", "/qb", "/i", "$env:SystemDrive\Windows\Temp\mongodb_database_latest.msi", "SHOULD_INSTALL_COMPASS=0", "ADDLOCAL=Router,ServerService" -Wait -ErrorAction Stop
} catch {
    Write-Host "Error installing MongoDB: $_." -ForegroundColor Red
}
﻿
To install MongoDB on another drive, you need to add — "INSTALLLOCATION=A:\MongoDB"
Create a directory for the MongoDB administration utilities:
PowerShell
if (-not (Test-Path "$env:ProgramFiles\MongoDB\Tools\")) {
    New-Item -ItemType Directory -Force -Path "$env:ProgramFiles\MongoDB\Tools\"
    Write-Host "Directory successfully created" -ForegroundColor Green
} else {
    Write-Host "Directory already exists"
}
if (-not (Test-Path "$env:ProgramFiles\MongoDB\Tools\")) {
    New-Item -ItemType Directory -Force -Path "$env:ProgramFiles\MongoDB\Tools\"
    Write-Host "Directory successfully created" -ForegroundColor Green
} else {
    Write-Host "Directory already exists"
}
﻿
Download administration utilities:
PowerShell
try {
    (New-Object System.Net.WebClient).DownloadFile(
        "https://repos.passwork.pro/repository/windows_packages/database_tools_latest.zip", 
        "$env:SystemDrive\Windows\Temp\database_tools_latest.zip"
    )
    Write-Host "Administration utilities loaded" -ForegroundColor Green
} catch {
    Write-Host "Error loading administration utilities: $_" -ForegroundColor Red
}
try {
    (New-Object System.Net.WebClient).DownloadFile(
        "https://repos.passwork.pro/repository/windows_packages/database_tools_latest.zip", 
        "$env:SystemDrive\Windows\Temp\database_tools_latest.zip"
    )
    Write-Host "Administration utilities loaded" -ForegroundColor Green
} catch {
    Write-Host "Error loading administration utilities: $_" -ForegroundColor Red
}
﻿
In case of an error, you can download the installer manually — https://repos.passwork.pro/repository/windows_packages/database_tools_latest.zip﻿
Unzip the content:
PowerShell
Expand-Archive `
    -Path "$env:SystemDrive\Windows\Temp\database_tools_latest.zip" `
    -DestinationPath "$env:ProgramFiles\MongoDB\Tools\"
Expand-Archive `
    -Path "$env:SystemDrive\Windows\Temp\database_tools_latest.zip" `
    -DestinationPath "$env:ProgramFiles\MongoDB\Tools\"
﻿
Perform a shell connection check:
PowerShell
cd "$env:ProgramFiles\MongoDB\Tools\"
.\mongosh mongodb://localhost:27017
cd "$env:ProgramFiles\MongoDB\Tools\"
.\mongosh mongodb://localhost:27017
﻿
Restore backup
If the connection to the shell is correct, restore the databases from the backup:
PowerShell
cd "$env:ProgramFiles\MongoDB\Tools\"
.\mongorestore --drop "C:\backup\mongo-xxxx-xx-xx_xx-xx"
cd "$env:ProgramFiles\MongoDB\Tools\"
.\mongorestore --drop "C:\backup\mongo-xxxx-xx-xx_xx-xx"
﻿
Open Passwork to verify correct operation.
Updated 10 Oct 2024
Did this page help you?
Configuring Windows Task Scheduler
Alma/Rocky/CentOS