Pasted

### MySQL ###
## Handy gist - https://gist.github.com/hofmannsven/9164408 ##
 
# dump DB
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
 
# dump DB and gzip
$ mysqldump --opt -u [uname] -p[pass] [dbname] | gzip > [dbname]-$(date +%Y%m%d-%H%M%S).sql.gz
 
# import DB dump
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
 
# import gzipped DB dump
$ gunzip < [dump].sql.gz | mysql -u [uname] -p[pass]
 
# import DB dumped to signel WP files per table
$ for sql in *.sql; do mysql -u [unape] -p[pass] [db_to_restore] <$sql; done
 
# import multiple SQL dumps in single run
$ cat *.sql | mysql -u [user] -p [db_to_restore]
 
# access mysql shell
$ mysql -u [user] -p
 
# show all databases
> show databases;
 
# create new database
> create database [database];
 
# select database
> use [database];
 
# Determine what database is in use
> select database();
 
# show all tables
> show tables;
 
# show table structure
> describe [table];
 
# inserting a record
> INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]');
 
# grant ALL access to user for * tables
> GRANT ALL ON database.* TO 'user'@'localhost';
 
# updating records
> UPDATE [table] SET [column] = '[updated-value]' WHERE [column] = [value];
 
### Search ###
 
# List and delete .svn directories
find . -name .svn -exec echo '{}' \;
find . -name .svn -exec rm -rf '{}' \;
 
# Find recursively in current directory
# 1) .JS and .CSS files
# 2) modified in less than 1 minute
# 3) not in paths that contains /cache/, /backupbuddy_, /plugins/ and /headway/
 
find . -type f -mmin -1 \( -name "*.js" -or -name "*.css" \) -not \( -path "*/cache/*" -or -path "*/backupbuddy_*/*" -or -path "*/plugins/*" -or -path "*/headway/*" \)
 
# Find all default WP themes
$ find /home -type d -wholename '*/wp-content/themes/*' | grep -v 'cache' | egrep '\/wp-\content\/themes\/(default|twenty)' | egrep '(ten|teen|elewen|twelve|default)$'
 
# Find all W3TotalCache exception errors
$ grep 'BrowserCache.php on line 191' /usr/local/apache/logs/error_log | grep '/home/' | sed 's/^\[.*\ in\ //' | sed 's/on\ line\ 191.*//' | sort | uniq | less
 
### Archiving ###
 
# Pack to TAR from file list
$ tar -cvf archive.tar -T filelist.txt
 
# List content of TAR.GZ w/o extracting archive
$ tar -tf file.tar.gz
 
# Extract content of TAR.GZ archive
$ tar -zxvf file.tar.gz
 
### Permissions ###
 
# Chown recursively
$ chown -R username. *
 
# Calculate size of currend directory
$ du -chs
 
# Get working folder name
$ echo ${PWD##*/}
 
# Set proper permissions in public_html
$ find $PWD -type d -exec chmod 755 {} \;
$ find $PWD -type f -exec chmod 644 {} \;
 
# Get username of any directory in /home on regular web server
if [[ "$PWD" == "/home/"* ]]; then
  USERNAME=$( pwd | cut -d "/" -f3 )
fi
 
### Scripting ###
 
# Prepend "some text" as 1st line to file - sed insert
sed -i '1s/^/some text\n/' FILE_NAME.ext
 
# Get current BASH script directory path
SCRIPT_DIR_PATH=$( dirname $0 )
 
# Check does file contain "some text" exact string in whole line
if ! grep -Fxq 'some text' FILE_NAME.ext
then
  echo "file does not contain string"
else
  echo "file contains string"
fi
 
### Debugging ###
 
# Compare two folders but exclude specific path
$ diff --exclude=directory/to/exclude -r dir1 dir2
 
# Compare files in two directories and print only file paths that differ
diff -qr dir1 dir2
 
# Compare files in two directories and print only file path that is same
diff -rs dir1 dir2 | egrep '^Files .+ and .+ are identical$'