AKZN Notes

Archives for My Lazy and Forgetful Mind

Category: IT Stuff

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

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

how to log mysql query that has long time to execute

To log slow-running MySQL queries, you can enable the Slow Query Log feature in MySQL. This log will record all queries that take longer than a specified amount of time to execute. Here’s how to set it up: Step 1: Enable Slow Query Logging To enable slow query logging, you need to modify the MySQL […]

How to pull new branch from github

To pull a new branch from GitHub, follow these steps using Git: 1. Fetch the new branch from the remote repository: Run the following command to fetch all branches from the remote repository. This will not switch to the branch yet, but it will download the branch references. git fetch origin 2. List all branches […]

Setting WDS Openwrt

problems saat ubah network interface lan, perubahan subnet kadang bikin harus reboot dulu baru kedetek cara : set firewall zone to lan set wireless > edit > interface or something, from wwan to lan Allow Luci accessed via [wan/bridged] MIKROTIK HOTSPOT i add bracket [wan] to point out that i want to access luci via […]