Backing Up WordPress Before Upgrade (and How to Restore)

For these instructions, wordpress_dir is your wordpress directory.

Find Database Username and Password
cat /var/www/wp-config.php | grep DB

or

cat /var/www/wordpress_dir/wp-config.php | grep DB
Backup Database
mysqldump --no-tablespaces -u wordpressuser -p wordpress_db | xz -9ec > wordpress_20191119.sql.xz
Move to WordPress Directory
cd /var/www
Move Config to WordPress Directory
sudo mv wp-config.php wordpress_dir
Archive WordPress Directory
tar Jcvf ~/wordpress_20191117.tar.xz wordpress_dir
Copy WordPress Directory
sudo cp -a wordpress_dir wordpress_dir.bak
Log in to MySQL
sudo mysql
Create New WordPress Database
CREATE DATABASE wordpress_20191119 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Grant Privileges to New Database
GRANT ALL ON wordpress_20191119.* TO 'wordpressuser'@'localhost';
FLUSH PRIVILEGES;
Load Backup to New Database
zxcat wordpress_20191119.sql.xz | mysql -u wordpressuser -p wordpress_20191119.sql.xz
Move to Web Directory to Restore Files
cd /var/www
Backup Up Current WordPress Directory
sudo mv wordpress_dir wordpress_dir_broke
Edit wp-config.php
sudo nano /var/www/wordpress_dir/wp-config.php
Edit “DB_Name” to wordpress_20191117

Control-o to save. Control-x to exit.

The website will now be restored

Move wp-config.php from wordpress_dir
sudo mv /var/www/wordpress_dir/wp-config.php /var/www/

Mounting Excalibur Scroll Saw to Kreg Universal Bench with MDF Top

I used the Kreg Universal Bench 20″x20″ with standard height legs. I also used their locking casters. Top is 4’x2′ MDF cut in half and glued together.

Kreg Universal Bench: https://amzn.to/2NZNdxM (Amazon Affiliate)
Portalign Style Drill Guides: https://amzn.to/35fwI6I (Amazon Affiliate)
3/8-16 bolts: https://amzn.to/2CVxcTb (Amazon Affiliate)
3/8-16 nylon nuts: https://amzn.to/2OoCRXf (Amazon Affiliate)
3/8 washers: https://amzn.to/33Uv5uN (Amazon Affiliate)
3/8 Drill Bits: https://amzn.to/2pt4xli (Amazon Affiliate)

Kreg KMA2900 Multi-Mark Multi-Purpose Marking and Measuring Tool (Amazon Affiliate)
US: https://amzn.to/2AaEgLL
UK: https://amzn.to/2Rjg1Si
CA: https://amzn.to/2Np0Ci4
ES: https://amzn.to/2VWPqh8
FR: https://amzn.to/2Z5uVk8
IT: https://amzn.to/38Ihie8
DE: https://amzn.to/2ZJm2fm

CACAGOO Mini Humidifier Unboxing and Review

CACAGOO Car Humidifier Car Diffuser Cool Mist Air Refresher 300mL USB Ultrasonic Humidifier with 7 Colorful LED Lights, Waterless Auto Shut-Off, for Car Travel Office Baby Room (BPA Free) (Amazon Affiliate)
US: https://amzn.to/2Xs7crZ
UK: https://amzn.to/2Z2lwK7
CA: https://amzn.to/38x4ruW
ES: https://amzn.to/38x4ruW
FR: https://amzn.to/31R25WI
IT: https://amzn.to/31UPWzS
DE: https://amzn.to/3gAcjyM

1997 Land Cruiser FZJ80 Rear Door Panel Removal (to Lube Lock)

Panel Clip Pliers: https://www.harborfreight.com/Panel-Clip-Pliers-63699.html
Toyota Trim Door Panel Retainer Clips: https://amzn.to/2L2d3Q9 (Amazon Affiliate)
CRC 05103 QD Electronic Cleaner: https://amzn.to/2QsvBMv (Amazon Affiliate)
CRC 05074 Heavy Duty Silicone: https://amzn.to/2CRQiK4 (Amazon Affiliate)

1997 Land Cruiser Playlist: https://www.youtube.com/playlist?list=PLErU2HjQZ_ZNTNDledQZp3VLGsMo1W1fQ