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 […]
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);
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 […]
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 […]
This article is my notes for step by step to install and configure set top box Armbian into kiosk device. List of Bugs browser failed to launch immediately solution : add sleep 60 before launching the browser display need to restart or reattach the hdmi cable if system rebooted. solution: use xrandr to relaunch the […]
how to backup all database To backup all MySQL data, you can follow these steps: Connect to your VPS: Log in to your VPS using SSH. Navigate to the MySQL data directory: MySQL data files are typically located in the /var/lib/mysql directory. Navigate to this directory by running the following command: cd /var/lib/mysql Create a […]
How to update your ci 3 version to 3.1.13 change config $config['sess_save_path'] = sys_get_temp_dir() add #[\ReturnTypeWillChange] before the open, read, write, close, destroy and gc functions in /system/libraries/Session/drivers/Session_files_driver.php example : #[\ReturnTypeWillChange] public function open($save_path, $name) { … update system/libraries/pagination.php line 526 from if ( ! ctype_digit($this->cur_page) OR ($this->use_page_numbers && (int) $this->cur_page === 0)) to if […]
Force HTTPS Using htaccess on WordPress Step 1: Update your general settings. Log into your WordPress dashboard ang go to Settings > General. Scroll down to the WordPress and Site URL Address field and replace the HTTP with HTTPS. Click the Save Changes button at the bottom of the page. You’ll be automatically logged out […]
Apache2 .htacess : makesure AllowOverride All on directory htdocs on httpd.conf PHP make sure all module installed Session : make sure session.save_path on php.ini is enabled SSL Letsencrypt make sure apache-ssl module installed sudo apk update & sudo apk upgrade & sudo apk add apache2-ssl sudo apk add certbot-apache sudo certbot certonly make site-avalaible conf […]