AKZN Notes

Archives for My Lazy and Forgetful Mind

Archives

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 […]

VNC Armbian Server Setup

https://forum.armbian.com/topic/10330-remote-desktop-with-x11vnc/ With this you can control your Linux desktop from any other PC/SBC. I use lightdm as display manager. If you use another display manager, change the line After=lightdm.service with your display manager. To Install sudo apt install x11vnc To create a password file x11vnc -storepasswd The service script : /lib/systemd/system/x11vnc.service [Unit] Description="x11vnc" Requires=display-manager.service After=lightdm.service […]

Migrate vps to a new vps

Tutorial: Clone a Disk Over SSH with Compression This guide explains how to clone a disk (/dev/sda) from a source machine to a destination machine over SSH using dd and gzip for compression. Prerequisites Source Machine: Ensure dd, gzip, and ssh are installed. Destination Machine: Ensure gzip and ssh are installed. Network Setup: Both machines […]

MikroTik PPPoE Bandwidth Management with RADIUS

Step 1: Configure PPPoE Basic PPPoE Setup: Set up your PPPoE server as you normally would. Ensure that you have configured the necessary interfaces and settings. Step 2: RADIUS Configuration Add RADIUS Attributes: In your RADIUS server, add the reply attribute Mikrotik-Address-List. This attribute will automatically add the IP address of the client logging in […]

MikroTik Hotspot Bandwidth Management

Hotspot Configuration Basic Settings: Configure the hotspot settings as usual. RADIUS Configuration (if applicable): In the server profile, enable the "Use RADIUS" option. Create a user profile and specify values in incoming[up]/outgoing-mark[down], such as packet-mark-download. This will dynamically add a packet mark in Mangle. Mikrotik-Group Attribute: If your RADIUS server uses the "Mikrotik-Group" attribute, ensure […]