Bùi Thế Hòa buithehoa

🐢

Moving slowly ...

buithehoa / start-stop-a-postgresql-cluster

Created November 23, 2017 13:45

sudo systemctl start/stop postgresql@<version>-<cluster>

buithehoa / copy-files-with-rsync.sh

Last active June 27, 2018 04:33

rsync -az --info=progress2 /source/folder /destination

buithehoa / enable-expanded-display

Created September 12, 2018 04:03

select * from some_table \x\g\x

buithehoa / extract-a-tgz-file

Last active September 21, 2018 10:26

Extract a .tgz file

tar -xvzf /path/to/file.tgz

buithehoa / count-the-number-of-tables-in-the-current-mysql-database

Created April 2, 2019 04:02

select count(*) from information_schema.tables where table_schema = database();

buithehoa / 17eaec52-e41e-480b-8635-495a05e19773

Last active August 23, 2021 14:18

.sub('-', ' ').gsub(/[\:\[\]\"\'-.#]/, '').gsub(/[\/(\s)]+/, '-').downcase

buithehoa / rsync-files-whose-names-match-a-pattern

Last active January 6, 2020 08:12

find . -maxdepth 1 -type f \( -iname '1[6-9]*flac' -o -iname '2[0-9]*.flac' \) -exec rsync -az --info=progress2 {} /somewhere/out/there \;

buithehoa / view-docker-container-logs.sh

Last active November 29, 2019 14:00

docker logs --tail 10 docker_container_name_or_id

buithehoa / revert-multiple-commits

Created February 26, 2020 08:08

git log --pretty=oneline | grep 'comment text' | cut -d ' ' -f1 | xargs -n1 git revert --no-edit

buithehoa / back-up-mysql-database-with-mysqldump

Last active January 2, 2021 07:48

mysqldump -u <username> -h <host> --password <database> > <file_name>.sql