Anton Anisimov AnisimovMoscow

## dump.sh
#!/bin/bash

# MySQL Database Backup Script

TODAY=`date +"%F"`

DB_BACKUP_PATH='/path/to/backup'
MYSQL_USER='user'
MYSQL_PASSWORD='password'
DATABASE_NAME=$1

## bitbucket2github.sh
git remote rename origin bitbucket
git remote add origin git@github.com:username/project.git
git push -u origin master
git remote rm bitbucket

## clear-swap.sh
sudo su
echo 3 > /proc/sys/vm/drop_caches && swapoff -a && swapon -a

## nginx-clear-cache.sh
find /var/lib/nginx/cache -type f -exec rm {} \;

## truncate.sh
truncate -s 0 filename.txt

## remove-unicode.php
<?php
//reject overly long 2 byte sequences, as well as characters above U+10000
$text = preg_replace('/[\x00-\x08\x10\x0B\x0C\x0E-\x19\x7F]'.
'|[\x00-\x7F][\x80-\xBF]+'.
'|([\xC0\xC1]|[\xF0-\xFF])[\x80-\xBF]*'.
'|[\xC2-\xDF]((?![\x80-\xBF])|[\x80-\xBF]{2,})'.
'|[\xE0-\xEF](([\x80-\xBF](?![\x80-\xBF]))|(?![\x80-\xBF]{2})|[\x80-\xBF]{3,})/S',
'', $text);

//reject overly long 3 byte sequences and UTF-16 surrogates

## remove-old-cores.sh
# Для удаления старых ядер, кроме последнего и предпоследнего, можно использовать команду
sudo apt-get purge $(dpkg -l 'linux-*' | sed '/^ii/!d;/'"$(uname -r | sed "s/\(.*\)-\([^0-9]\+\)/\1/")"'/d;s/^[^ ]* [^ ]* \([^ ]*\).*/\1/;/[0-9]/!d' | head -n -1)

# а после этого выполнить
sudo apt-get autoremove

## dir-size.sh
du -h --max-depth=1

## cache.sql
/* Статистика кеша */
SHOW GLOBAL STATUS LIKE 'Qcache%';

/* Настройки кеша */
SHOW VARIABLES LIKE 'query_cache%';

## where-count.sql
SELECT COUNT(IF(a>0,1,null)), COUNT(*) FROM t
	#!/bin/bash

	# MySQL Database Backup Script

	TODAY=`date +"%F"`

	DB_BACKUP_PATH='/path/to/backup'
	MYSQL_USER='user'
	MYSQL_PASSWORD='password'
	DATABASE_NAME=$1
	git remote rename origin bitbucket
	git remote add origin git@github.com:username/project.git
	git push -u origin master
	git remote rm bitbucket
	sudo su
	echo 3 > /proc/sys/vm/drop_caches && swapoff -a && swapon -a
	/* Статистика кеша */
	SHOW GLOBAL STATUS LIKE 'Qcache%';

	/* Настройки кеша */
	SHOW VARIABLES LIKE 'query_cache%';