Thursday, January 22, 2026

Update Ubuntu Swapfile

---- create swapfile2---- 

sudo fallocate -l 4G /swapfile2

sudo chmod 600 /swapfile2

sudo mkswap /swapfile2

sudo swapon /swapfile2


--remove old----

sudo swapoff /swapfile

sudo rm -f /swapfile

Wednesday, January 21, 2026

Import backup file into MYSQL

For example, if your file is in your current folder and your username is root:

 mysql -u root -p dbname < backup_file.sql


Monday, January 19, 2026

Error Open Word 2019 on Mac M1

 Error:

Microsoft Error Reporting log version: 2.0 Error Signature: Exception: EXC_BAD_ACCESS ExceptionEnumString: 1 Exception Code: KERN_INVALID_ADDRESS (0x0000000000000000) Date/Time: 2026-01-19 11:55:43 +0000

Solution

rm -rf ~/Library/Containers/com.microsoft.Word

rm -rf ~/Library/Group\ Containers/UBF8T346G9.Office


open -a "Microsoft Word" --args -safe

Saturday, January 17, 2026

Check Cloud-Init override (VERY IMPORTANT on Ubuntu 20)

 Ubuntu 20 often overrides SSH settings here:

sudo nano /etc/ssh/sshd_config.d/50-cloud-init.conf

Change to:

PasswordAuthentication yes
PermitRootLogin yes

or 

sudo nano /etc/ssh/sshd_config


PermitRootLogin yes
PasswordAuthentication yes
PubkeyAuthentication yes
UsePAM yes

sudo passwd root

sudo systemctl restart ssh

sudo systemctl status ssh



Wednesday, October 8, 2025

That error happens because with sql_mode including NO_ZERO_DATE or STRICT_TRANS_TABLES

That error happens because MySQL 5.7+ (and MariaDB 10.2+) with sql_mode including NO_ZERO_DATE or STRICT_TRANS_TABLES no longer allows default datetime values like '0000-00-00 00:00:00'.


SET GLOBAL sql_mode = '';

SET SESSION sql_mode = '';


Change Path Word Press from Old to New Domain

 UPDATE wp_options SET option_value = REPLACE(option_value, 'old-domain.com', 'new-domain.com');

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'old-domain.com', 'new-domain.com'');

UPDATE wp_posts SET guid = REPLACE(guid, 'old-domain.com', 'new-domain.com'');

UPDATE wp_posts SET post_content = REPLACE(post_content, 'old-domain.com', 'new-domain.com'');


-----Check if your uploads URL setting is wrong-----

SELECT * FROM wp_options WHERE option_name = 'upload_url_path';

UPDATE wp_options SET option_value = 'https://old-domain.com/wp-content/uploads' WHERE option_name = 'upload_url_path';


wp-config.php

define('WP_HOME', 'https://new-domain.com');

define('WP_SITEURL', 'https://new-domain.com');