Fernando Chicaiza washopilot

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

The best way to download a website for offline use, using wget

There are two ways - the first way is just one command run plainly in front of you; the second one runs in the background and in a different instance so you can get out of your ssh session and it will continue.

First make a folder to download the websites to and begin your downloading: (note if downloading www.SOME_WEBSITE.com, you will get a folder like this: /websitedl/www.SOME_WEBSITE.com/)

STEP 1:

Installing Arch linux with EFI

Change keyboard layout:
- loadkeys no
Verify boot mode:
- ls /sys/firmware/efi/efivars (If the directory exist your computer supports EFI)
Ping some site on the Internet to verify connection:

ping archlinux.org

Electron is tricky to get set up on Windows Subsystem for Linux, but it can work!

Four things needed overall:

you need WSL2, not WSL1
you need node, of course, and that part isn't so bad
you need to apt install several dependencies
you need an X Server so it can display the electron GUI over in Windows-land

Setup instructions, in order:

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	FROM php:7.2-fpm

	# Replace shell with bash so we can source files
	RUN rm /bin/sh && ln -s /bin/bash /bin/sh

	# make sure apt is up to date
	RUN apt-get update --fix-missing
	RUN apt-get install -y curl
	RUN apt-get install -y build-essential libssl-dev zlib1g-dev libpng-dev libjpeg-dev libfreetype6-dev