AKZN Notes

Archives for My Lazy and Forgetful Mind

Archives

iPerf3 on Windows 11 with Docker

# iPerf3 on Windows 11 with Docker This guide explains how to install Docker Desktop on Windows 11, run iPerf3 for network performance testing, and use a single .bat script for quick local, remote, and dual-direction tests. — ## 1. Install Docker Desktop 1. Download Docker Desktop: – [https://www.docker.com/products/docker-desktop/](https://www.docker.com/products/docker-desktop/) 2. Install it with **WSL 2 […]

How to Remove a Specific Command from PowerShell History in VS Code

How to Remove a Specific Command from PowerShell History in VS Code If you accidentally typed a password or sensitive command in the VS Code terminal using PowerShell, and you want to remove only that specific command from history, follow these steps: 📂 Step-by-Step Instructions Close the VS Code terminal to prevent file locking. Open […]

Setting Bridge Network With WDS on BOLT BL-201

Setting Bridge Network With WDS on BOLT BL-201 Server (AP – Access Point) Wireless Mode: Access Point (AP) Enable WDS: Yes SSID: Set your preferred SSID Encryption: WPA2-PSK (recommended) Key: Set your Wi-Fi password Assign to network: LAN Network → Interfaces br-lan: Interface for LAN Static IP: e.g., 192.168.1.1/24 Firewall zone: LAN Firewall Ensure LAN […]

Upgrade Mysql / MariaDB version 10.1.xx to 10.6.xx on XAMPP Windows

To upgrade MariaDB in XAMPP, follow these steps carefully: 🔄 Replace MariaDB in XAMPP with a New Version ✅ 1. Backup your data Copy: \xampp\mysql\data → \xampp\mysql_backup\data Or export all DBs via phpMyAdmin. ✅ 2. Download MariaDB (ZIP version) Go to: https://downloads.mariadb.org/ Choose version 10.6 or later. Select Windows ZIP Archive, e.g.: mariadb-10.6.16-winx64.zip ✅ 3. […]

How to import big table using mysql command on terminal

Understanding the MySQL Import Command with Custom Parameters When importing large SQL dump files into MySQL, it is often necessary to adjust MySQL’s configuration parameters to handle large queries and improve performance. The following command is an example of importing a database dump while customizing MySQL’s memory settings and disabling foreign key checks: "D:\xampp\mysql\bin\mysql" –max_allowed_packet=512M […]

How to Backup VPS to Home Server using BORG

To back up your VPS to your home server using BorgBackup, follow these steps: 1. Install Borg on Both VPS & Home Server On VPS: sudo apt update && sudo apt install borgbackup -y On Home Server: sudo apt update && sudo apt install borgbackup -y 2. Set Up SSH Access (Passwordless Login) On your […]

laravel Migration Specified key was too long problem

https://stackoverflow.com/questions/42244541/laravel-migration-error-syntax-error-or-access-violation-1071-specified-key-wa check if ‘mysql’ => [ …, …, ‘engine’ => env(‘DB_ENGINE’, ‘InnoDB’), ] or InnoDB ROW_FORMAT=DYNAMIC solve the problem, if still error, try accepted answer about Schema::defaultStringLength(191);

How to Composer Install using different php version

1. Find Composer Installation Path Windows Run the following command to check system paths: php -r "echo getenv('PATH');" Look for a path similar to: C:\ProgramData\ComposerSetup\bin\ Or search for "composer" in the output. linux no need to search phar, we can use which below 2. Run Composer Using a Specific PHP Version Windows Once you find […]

Tutorial Installasi dan Koneksi Printer POS58 serta Drawer

Cara Install POS58 Install Driver POS58 Unduh driver dari Google Drive. Instal driver sesuai petunjuk instalasi bawaan file. Koneksikan Printer Thermal ke PC (Bluetooth – Windows 10) Nyalakan Bluetooth pada printer dan PC. Pasangkan perangkat dengan memilih RPP02N. Pilih opsi Bluetooth (bukan "Wireless Display"). Gunakan password pairing: 0000. Cek Port Koneksi di Device Manager Buka […]

Import Database into XAMPP MYSQL via Windows Shell / Command Prompt

Import Database into XAMPP MySQL via Windows Shell / Command Prompt When working with MySQL in XAMPP, importing a database via the command prompt is a quick and efficient option. This tutorial explains how to use the Windows Shell to import a database into XAMPP MySQL. Prerequisites XAMPP Installed: Ensure XAMPP is installed on your […]