Useful Linux Commands

I find myself searching for these commands more often than I should. So, until my mush brain remembers these I'll write them down here.

Archive a directory

tar -zcvf .tar.gz /DIR/You/WANT/TO/ARCHIVE 

Extract .tar.gz file

tar -xvzf {filename.tar.gz} 

MySQL

mysqldump -u {USER} -p {DATABASE_NAME} > {FILENAME.sql} 

 mysql -u {USER} -p {DATABASE_NAME} < {FILENAME.sql} 

SCP

Copy local file to destination

 scp {LOCAL.file} {USER}@{SERVER.COM}:{~/path/to/destination} 

 scp -i {/path/to/pem.file} {USER}@{SERVER.COM}:{~/path/to/file} {/path/to/local/file} 

Compile all access statistics from Jul 4-6 2013

find ./*/statistics/logs/access_log* -mtime -5 -exec zgrep -E "0[4-6]/Jul/2013:" {} \; > /root/Jul_04-06_logs.txt 

Find files modified within the last 7 days

find /var/www/vhosts/*/httpdocs -type f -mtime -7 find /var/www/vhosts/*/httpdocs -type f -mtime -7 | xargs ls -lct > /root/recent_modified.log 

Find files modified within the last 5 days sorted by newest first

find /var/www/vhosts/*/httpdocs/ -mtime -5 -type f -print0 | xargs -0 ls -al | sort -r 

Count IP addresses in Apache log files

cat access.log | cut -d ' ' -f 1 | sort | uniq -c | sort -n 

Compile a specific VHOST from the Apache 'other vhosts' Log files

find . -type f -exec grep 'VIRTUAL_HOST' '{}' \; > VIRTUAL_HOST.txt 

Sum the file size from the ls command

ls -l | grep -e 'filename' | awk '{COUNT+=$5} END {print COUNT}'

Find the port number that a process is using

netstat -ltnp | grep -w ':80'

netstat -ltnp | grep '20000'