Skip to content

Instantly share code, notes, and snippets.

View stepansib's full-sized avatar

Stepan Yudin stepansib

View GitHub Profile
@stepansib
stepansib / database size.sql
Created August 30, 2018 08:51
#crm database size
SELECT
table_schema AS `Database`,
table_name AS `Table`,
ROUND(
(
(data_length + index_length) / 1024 / 1024
),
2
) `MB`,
TABLE_ROWS AS `Rows`
@stepansib
stepansib / cleanup.sh
Last active January 24, 2019 11:57
#git cleanup
git checkout master
git branch --merged | egrep -v "(^\*|master|dev)" | xargs git branch -d
git gc --aggressive --prune=now
@stepansib
stepansib / cleanup.sh
Last active February 24, 2019 18:27
#docker cleanup
docker system prune -a --volumes
@stepansib
stepansib / mysql_backup.sh
Last active February 20, 2020 11:31
#db mysql backup
# Backup:
mysqldump -h HOST -u USER -pPASSWORD DATABASE | gzip > /backup.sql.gz
mysqldump --no-data -h HOST -u USER -pPASSWORD DATABASE | gzip > /backup.sql.gz
mysqldump -h HOST -u USER -pPASSWORD DATABASE TABLE1 TABLE2 | gzip > /backup.sql.gz
# Restore
gunzip < backup.sql.gz | mysql -h HOST -u USER -pPASSWORD DATABASE
@stepansib
stepansib / faketime_example.sh
Last active March 22, 2019 06:56
#linux faketime example
faketime "2019-03-08 12:00:00" date
@stepansib
stepansib / tar_directory.sh
Last active March 22, 2019 06:56
#linux tar directory
tar -czf cache.tar.gz ../cache/
tar -czf vendor.tar.gz ../vendor/
tar -czf node_modules.tar.gz ./node_modules/
@stepansib
stepansib / compose_commands.sh
Created March 14, 2019 14:38
#docker compose commands
docker-compose ps
docker-compose up -d --build --remove-orphans
docker-compose stop
docker-compose stop && docker-compose up -d --build --remove-orphans
docker-compose down && docker-compose pull && docker-compose build --pull && docker-compose up -d --build --remove-orphans
docker-compose pull
@stepansib
stepansib / check_OVPN_config.sh
Last active March 20, 2019 14:30
#linux #vpn check OVPN config
sudo nmcli connection import type openvpn file FILE_NAME
https://askubuntu.com/questions/760345/cannot-import-saved-openvpn-configuration-file-in-ubuntu-16-04-lts
@stepansib
stepansib / bluetooth_on_startup.sh
Created March 20, 2019 15:02
#linux enable/disable bluetooth on startup
sudo systemctl disable bluetooth.service
sudo systemctl enable bluetooth.service
@stepansib
stepansib / remove_accessibility_menu.txt
Created March 20, 2019 15:05
#linux remove accessibility menu
https://askubuntu.com/questions/1053221/how-to-not-to-show-universal-access-menu-icon-in-task-bar-in-ubuntu-18-04