Bash to docker
In order to log to running container
docker exec -it CONTAINER_ID /bin/bash
Ansible discovered information -> facts
ansible hostname -m setup
Bash operators
File operators:
Sql cheat sheet
Posgtesql cheat sheet, use with caution, most compatible with mysql
connect to db\c db_name;
create databasecreate database db_name;
list databases\l
vim extra space when copy
Turn off adding spaces to newline when copy to vim
:set paste
revert with:set nopaste
Postgresql wipe db
How to clean postgresql db without actually dropping it
connect to desired db\c db_name
check db schema\dn
delete tablesDROP SCHEMA public CASCADE;CREATE SCHEMA public;
tar
tartar -zcvf prog-1-jan-2005.tar.gz /home/jerry/prog
untar$ tar -zxvf prog-1-jan-2005.tar.gz
Check certificate information
openssl x509 -text -noout -in
Check db size
Check mysql
SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "DB_name" ORDER BY (data_length + index_length) DESC;