Notes on and cheat sheet for SSH, Linus, Bash...

Linux, SSH, Bash Scratchpad

#  Find files named aida.pdf, aida.png, etc. anywhere 

  find ~/* -name "aida*"

#  More on find
#  http://www.codecoffee.com/tipsforlinux/articles/21.html


#  Show size of subdirectories, total 
#  disk usage (estimated) | sorted by numerical value

  du -smc * | sort -n


##########################################################################
## Backing-up/Cloning a MySQL5 database 
#  (tested with provider 1&1, shared hosting)

##  DB Dump 
#  db -> sql

  mysqldump --host=dbxxxxxxxxx.db.1and1.com --u=dboyyyyyyyyy 
  --password=11111111 dbzzzzzzzzz > db_production.sql --socket=/tmp/mysql5.sock

##  DB Restore/Setup
#  sql -> db

  mysql --host=dbxxxxxxxxx.db.1and1.com --user=dboyyyyyyyyy 
  --password=22222222 -S /tmp/mysql5.sock dbzzzzzzzzz < db_production.sql 


##########################################################################
## Backing-up entire directories

##  compress directory 
#  --exclude='/htdocs/logs/*' 
##  to avoid including directories in use or too large

  tar -cvzf yyyy-mm-dd-images.tar  images/

##  open new terminal and copy remote archive to local destination

  scp pXXXXXXXX@example.com:/customers/homepages/00/d111111111/htdocs/images/yyyy-mm-dd-images.tar /Applications/MAMP/htdocs/example.com/images

##  uncompress

  cd /Applications/MAMP/htdocs/example.com/images
  tar xf yyyy-mm-dd-images.tar

##  check result

  ls images