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

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

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

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

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');

Updated IP Routing

 eth1 is DOWN (state DOWN) - it's not activated

No default route in the routing table

eth0 doesn't have an IP address assigned (or it's not showing in routing)

DNS is failing because there's no network connectivity

Let's troubleshoot step by step:

1. First, check if eth0 has the IP address:

bash

ip addr show eth0

2. Bring up eth1 interface:

bash

sudo ip link set eth1 up

3. Check current IP configuration:

bash

ip addr show

4. If eth0 doesn't have the IP, assign it manually:

bash

sudo ip addr add xxx.xxx.xxx.xxx/20 dev eth0

5. Add the default gateway:

bash

sudo ip route add default via xxx.xxx.xxx.x dev eth0

6. Test connectivity:

ping -c 4 xxx.xxx.xx.x  # Test gateway first

ping -c 4 8.8.8.8       # Test internet