Patrick Tully mrpatrick

## remove_known_host.sh
ssh-keygen -R [HOSTNAME]

## largest_tables.mysql
SELECT CONCAT(table_schema, '.', table_name),
       CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,
       CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,
       CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,
       CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
       ROUND(index_length / data_length, 2)                                           idxfrac
FROM   information_schema.TABLES
ORDER  BY data_length + index_length DESC
LIMIT  20;

## git_subtree_add.sh
# Works with master branch
git subtree add --squash --prefix=circle git@github.com:avatarnewyork/circleci.git master

## docker-exec.sh
# where the container is 0f4fe0b1f413
docker exec -i -t 0f4fe0b1f413 bash

# or for an apache instance
docker exec -ti projectname_projectname_1 /bin/bash

# or for example mysql
docker exec -ti projectname_db_1 /bin/bash


## docker_rm_except.sh
docker rm $(docker ps -a |grep -v RUNNING_CONTAINER_NAME | awk '{print $1}')

## gzip_uncompressed_file_size.sh
#!/bin/bash
time zcat test.gz| wc -c

## rest_drupal_pwd.sh
drush upwd admin --password="s3cr3t"

## git_patch_file_branches.sh
# On branch master
git checkout gh-pages
git checkout master -- myplugin.js
git commit -m "Update myplugin.js from master"

## bad_robots_access_logs.sh
cat access_log | awk -F\" '{print $6}' | sort | uniq -c | sort -n |grep bot

## force_git_pointer.sh
git branch -f stage release-v1.0.1
git push -f origin stage
	SELECT CONCAT(table_schema, '.', table_name),
	CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
	CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
	CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
	CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
	ROUND(index_length / data_length, 2) idxfrac
	FROM information_schema.TABLES
	ORDER BY data_length + index_length DESC
	LIMIT 20;
	# Works with master branch
	git subtree add --squash --prefix=circle git@github.com:avatarnewyork/circleci.git master
	# where the container is 0f4fe0b1f413
	docker exec -i -t 0f4fe0b1f413 bash

	# or for an apache instance
	docker exec -ti projectname_projectname_1 /bin/bash

	# or for example mysql
	docker exec -ti projectname_db_1 /bin/bash
	# On branch master
	git checkout gh-pages
	git checkout master -- myplugin.js
	git commit -m "Update myplugin.js from master"