stepansib

SELECT
  table_schema AS `Database`,
  table_name AS `Table`,
  ROUND(
    (
      (data_length + index_length) / 1024 / 1024
    ),
    2
  ) `MB`,
  TABLE_ROWS AS `Rows`

stepansib

git checkout master
git branch --merged | egrep -v "(^\*|master|dev)" | xargs git branch -d
git gc --aggressive --prune=now

stepansib

docker system prune -a --volumes

stepansib

# 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

faketime "2019-03-08 12:00:00" date

stepansib

tar -czf cache.tar.gz ../cache/
tar -czf vendor.tar.gz ../vendor/
tar -czf node_modules.tar.gz ./node_modules/

stepansib

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

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

sudo systemctl disable bluetooth.service
sudo systemctl enable bluetooth.service

stepansib

https://askubuntu.com/questions/1053221/how-to-not-to-show-universal-access-menu-icon-in-task-bar-in-ubuntu-18-04