dfirhub

HeidiSQL

Author: Hyun Yi @hyuunnn

description

HeidiSQL

paths

2 paths
AppsHeidiSQL Backup files (*.sql)
C:\Users\%user%\AppData\Roaming\HeidiSQL\Backups\
AppsHeidiSQL (tabs.ini)
C:\Users\%user%\AppData\Roaming\HeidiSQL\tabs.ini
paths use Windows environment syntax

collection commands

# PowerShell Artifact Collection Script
# Target: HeidiSQL
# Run as Administrator

#Requires -RunAsAdministrator

$ErrorActionPreference = "SilentlyContinue"
$DestBase = "D:\Evidence"

# Function to handle directory creation and copying
function Collect-Artifact {
    param (
        [string]$SourcePath,
        [string]$FolderName
    )
    $FullDest = Join-Path -Path $DestBase -ChildPath $FolderName
    if (-not (Test-Path -Path $FullDest)) {
        New-Item -ItemType Directory -Path $FullDest -Force | Out-Null
    }
    Copy-Item -Path $SourcePath -Destination $FullDest -Recurse -Force
}

# 1. HeidiSQL Backup files (*.sql)
$UserPath = Join-Path $env:USERPROFILE "AppData\Roaming\HeidiSQL\Backups\"
Collect-Artifact -SourcePath "$UserPath\*" -FolderName "HeidiSQL_Backup_files____sql_"

# 2. HeidiSQL (tabs.ini)
$UserPath = Join-Path $env:USERPROFILE "AppData\Roaming\HeidiSQL\"
Collect-Artifact -SourcePath "$UserPath\tabs.ini" -FolderName "HeidiSQL__tabs_ini_"

Write-Host "Collection complete!" -ForegroundColor Green

Save as .ps1 and run as Administrator. Use: powershell -ExecutionPolicy Bypass -File script.ps1

references