Proper Full Backup MYSQL Database

mysqldump -u myuser -p --single-transaction --routines --triggers --events database_name > full_backup.sql

Delete Plugin Wordpress Required FTP

 chown -R www-data:www-data /var/www/directory_name

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