cmpscabral

watch -n 5 --differences "mysql -u root -p -e 'show processlist'"

cmpscabral

# tar.gz
tar -xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database

# sql.gz
pv mydump.sql.gz | gunzip | mysql -u root -p

cmpscabral

cat access.log | awk '{print $1}' | sort -n | uniq -c | sort -nr | head -20

cmpscabral

mkdir -p media/content/images/cms-images
mkdir -p webservice/uploads
rm -f app/etc/use_cache.ser
mkdir -p var/cache var/report var/locks var/log var/session var/logging
mkdir -p media/catalog/product

svn revert webservice/.htaccess
svn revert webservice/.htpasswd
svn revert app/etc/local.xml

cmpscabral

alias vssh="cd /Users/miguel/Vagrant/ && vagrant ssh -- -t 'sudo su; cd /home/www/'"
alias vup="cd /Users/miguel/Vagrant/ && vagrant up"
alias vprov="cd /Users/miguel/Vagrant/ && vagrant provision"
alias vrestart="killall -9 ruby; cd /Users/miguel/Vagrant && vagrant halt && vagrant up"

cmpscabral

ssh -N -D 0.0.0.0:1080 localhost

cmpscabral

Client-side SSL

For excessively paranoid client authentication.

Using self-signed certificate.

Create a Certificate Authority root (which represents this server)

Organization & Common Name: Some human identifier for this server CA.

openssl genrsa -des3 -out ca.key 4096
openssl req -new -x509 -days 365 -key ca.key -out ca.crt

cmpscabral

find $LOCATION -name $REQUIRED_FILES -type f -mmin +360 -delete

cmpscabral

SELECT 
  -- Assumed to be trimmed
  name
  
  -- Does name contain multiple words?
  ,(LOCATE(' ', name) = 0) AS hasMultipleWords

  -- Returns the end of the string back until reaches a space. 
  --   E.g. "John Doe" => "Doe"
  --   E.g. "Francis Scott Key" => "Key"

cmpscabral

tree -ifDt --timefmt=%F