Archives for My Lazy and Forgetful Mind
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 […]
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 […]
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);
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 […]
HTTP Authentication is a method of securing web resources by requiring users to provide valid credentials before accessing them. It operates at the HTTP protocol level and can be implemented using several authentication schemes. One common method for HTTP Authentication is Basic Authentication, which prompts users to enter their username and password in a dialog […]
Importing MySQL Gzipped Dump File via Terminal When dealing with MySQL databases, it’s common to export and import data for various reasons, such as backups or transferring data between environments. In this concise guide, we’ll focus on importing a gzipped MySQL dump file using the terminal on a system running Ubuntu. Step 1: Navigate to […]
Introduction: Setting the correct timezone on your Ubuntu system is crucial for accurate timekeeping and proper synchronization. In this article, we will guide you through the process of permanently setting the timezone to UTC+7 (Indochina Time, ICT) using the timedatectl command. Step 1: Open a Terminal Open a terminal on your Ubuntu system. You can […]
Below is a simple Markdown tutorial for configuring Apache to run two PHP versions (PHP 7.4 and PHP 8.0) concurrently using PHP-FPM. This assumes you’re using a Linux system with Apache. Running Multiple PHP Versions with Apache and PHP-FPM before starting, check if we already has two php version sudo update-alternatives –display php Prerequisites Linux […]
Deploying a Node.js application to a Virtual Private Server (VPS) is a crucial step in bringing your web applications to life. In this guide, we’ll walk you through the process of setting up your VPS, transferring your Node.js code, and configuring the server to host your application efficiently. Deploy to VPS Set Up Your VPS: […]
Step-by-Step Guide: Deploying a Golang API Backend on a Linux Server Prerequisites: You have a Golang API project ready. You have access to a Linux server. Apache is installed and properly configured on the server. Deployment Steps: 1. Check the .env File: Ensure your Golang project has a properly configured .env file containing all the […]