Useful Unix Commands

useful

#sql-restore-files
for SQL in *.sql.gz; do DB=${SQL/\.sql.gz/}; echo importing $DB; zcat $SQL | mysql -u root --password='{PASSWORD}' $DB; done

#backup all directories and compress them
find ./* -maxdepth 0 -type d -exec echo "Archiving {}" \; -exec tar -cjf "{BACKUP_DIR}/{}-{DATE}.tar.bz2" \;

#find and replace in files recursive without touching files that dont match
find ./ -type f -name '*.php' -print0 | xargs -0 grep 'FIND' -l | xargs sed -i 's/FIND/REPLACE/g'

#apache max clients recommendation
ps aux | egrep "^apache.*httpd" | awk -v mem=`free -m | grep Mem | awk '{print $2}'` '{sum+=$6} END {printf "Total Processes: %13s\nTotal RAM: %23s KB\nTotal RAM: %23s MB\nAvg RAM per Proc: %17s MB\nMax Recommended Clients: %10s\n", NR,sum,sum/1024,sum/NR/1024,(mem*.7)/(sum/NR/1024)}'