🔥🍺 CHEAT SHEETS 🍺🔥 - Opens on Alfred keyword: "help"

lamp.md

📕 LAMP 📘 MySQL 📘 Terminal 📘 htaccess

---

UPDATE UBUNTU

sudo apt-get update
sudo apt-get -f install
sudo apt-get upgrade
sudo apt-get dist-upgrade
sudo reboot

APACHE

sudo apachectl configtest
sudo service apache2 {start|stop|restart}
sudo vi /etc/apache2/apache2.conf
tail -f /var/log/apache2/error.log

cd /etc/apache2/sites-available/
sudo a2ensite example.com.conf
sudo a2dissite /etc/apache2/sites-available/{.conf}

sudo find /etc/letsencrypt/ -name "*example.com*"
sudo find /etc/apache2/ -name "*example.com*"

ps aux | grep apache
sudo killall apache2

Apache+LE DELETE SITE

sudo rm -rf /etc/letsencrypt/live/example.com
sudo rm -rf /etc/letsencrypt/renewal/example.com.conf
sudo rm -rf /etc/letsencrypt/archive/example.com

cd /etc/apache2/sites-available/
sudo a2dissite example.com.conf
sudo a2dissite example.com-le-ssl.conf

rm -rf /etc/apache2/sites-available/example.com-le-ssl.conf
rm -rf /etc/apache2/sites-available/example.com.conf

WORDPRESS (WPCLI)

wordpress
wp core update
wp plugin update --all --skip-plugins
wp theme update --all --skip-plugins
wp gf update
wp cli update
~/bin/wp  
wp site list
wp plugin install {PLUGIN}
wp plugin activate {PLUGIN} --url={URL}
wp scaffold
wp scaffold plugin
wp search-replace
wp db export --tables=$(wp db tables 'wp_123_*' --format=csv)
wp db export --tables=$(wp db tables 'wp_123_*' --format=csv --url=https://network.example.com/siteslug/)

LETS ENCRYPT

cd /opt/letsencrypt
sudo ./letsencrypt-auto --apache -d example.com -d www.example.com
sudo ./letsencrypt-auto renew
# or
sudo certbot --apache -d domain.com -d www.domain.com
sudo certbot renew

find /etc/letsencrypt/ -name "*domaintodelete*"

GO ACCESS

sudo goaccess -f /var/log/apache2/access.log -c

--date-format %d/%b/%Y
--time-format %H:%M:%S

PHPMYADMIN

/usr/share/phpmyadmin
sudo vi /etc/phpmyadmin/.htpasswd
sudo vi /etc/phpmyadmin/apache.conf
sudo vi /etc/phpmyadmin/config.inc.php
/usr/share/phpmyadmin/config.inc.php #symbolic link

PHP - modapache

sudo vi /etc/php/7.2/apache2/php.ini
sudo vi /etc/php/7.2/cli/php.ini

PHP - fpm

sudo service php7.2-fpm restart
sudo tail -n 142 /var/log/php7.2-fpm.log
sudo vi /etc/php/7.2/fpm/pool.d/www.conf
ps -ylC php-fpm --sort:rss -u www-data

MAIL / SENDMAIL

sudo vi /etc/mail/sendmail.mc
sudo vi /etc/mail/local-host-names
sudo sendmailconfig
sudo /etc/init.d/sendmail restart
sudo vi /etc/aliases
sudo newaliases
sudo tail -f /var/log/mail.err
sudo tail -f /var/log/mail.log
sudo vi /etc/cron.d/sendmail
mailq
sudo sendmail -v -q

MYSQL

sudo service mysql {start|stop}
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
sudo vi /lib/systemd/system/mysql.service
systemctl daemon-reload
systemctl restart mysql.service
sudo tail -f /var/log/mysql/error.log

.SQL FIND+REPLACE

LC_CTYPE=C && LANG=C && sed -i -e 's|oldstring|newstring|g' export.sql

BITNAMI SETUP

sudo nano /opt/bitnami/php/etc/php.ini
sudo tail -f /opt/bitnami/apache2/logs/error_log
sudo /opt/bitnami/ctlscript.sh restart apache
sudo /opt/bitnami/ctlscript.sh restart php-fpm

SYMBOLIC LINKING

ln -s {DESTINATION} {ALIAS}

HOMEBREW (APACHE & PHP w/ sphp)

sudo apachectl start        🔥if unable to connect, this usually fixes
sudo apachectl stop
sudo apachectl -k restart

vi /usr/local/etc/httpd/httpd.conf
vi /usr/local/etc/httpd/extra/httpd-vhosts.conf

sudo tail -f /usr/local/var/log/httpd/error_log

vi /usr/local/etc/php/5.4/php.ini
vi /usr/local/etc/php/5.6/php.ini
vi /usr/local/etc/php/7.0/php.ini
vi /usr/local/etc/php/7.2/php.ini

sphp 54
sphp 55
sphp 56
sphp 70
sphp 71

brew update    # for php update, run sphpX then update
brew upgrade   # for php upgrade, run sphpX then upgrade

apachectl -V | grep httpd.conf

/usr/local/Cellar/php54/5.4.45_6
//...
/usr/local/Cellar/php71/7.1.6_18