oliveira-andre · October 1, 2024 02:10 · lucasdepvh · Aug 10, 2018
diff --git a/commandsheat linux b/commandsheat linux
 #execute mariadb container
 sudo docker exec -it mariadb  mysql -u root -p

 # importing data.sql to a database
 sudo docker exec -i mariadb  mysql -uroot -proot database < data.sql

 # connect to postgres container
 docker exec -it postgres psql

 # setup postgres new user and db
 CREATE USER devandre WITH PASSWORD 'your_new_password';
 CREATE DATABASE dev_andre_development;
 GRANT ALL PRIVILEGES ON DATABASE dev_andre_development to devandre;
 ALTER DATABASE dev_andre_development OWNER TO devandre;

 # start postgres on macos
 pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

 # stop postgres on mac
 pg_ctl -D /usr/local/var/postgres stop -s -m fast

 # import data.sql to a database in postgres
 psql -U password_manager -d password_manager_production < data.sql

 # with docker
 sudo docker exec -i container_name /bin/bash -c "PGPASSWORD=pg_pass psql --username pg_user database_name" < data.sql

 # export data.sql from a database postgres container
 sudo docker exec -it container_name pg_dump -U user db_name > data.sql

 # export pg db
 pg_dump db_name > data_dump

 # execute mongodb container
 sudo docker exec -it mongodb mongo

 # create user on mongodb
 db.createUser({ user: 'devandre', pwd: 'my_password_1234', roles: [{ role: 'readWrite', db: 'dev_andre_development' }] })

 # kill any process on some port on linux
 sudo kill $(sudo lsof -t -i:3000)

 # change yout default terminal
 sudo update-alternatives --config x-terminal-emulator

 # copy to clipboard by terminal
 pbcopy < ~/.ssh/id_rsa.pub

 or

 grep "<keyword>" | pbcopy


 # pasting from clipboard by terminal
 grep "<keyword>" | tee myfile.txt

 # show terminal calendar
 cal

 # encrypting files on VIM
 :X

 # adding linux to platforms on gem lock
 bundle lock --add-platform x86_64-linux-musl

 # installing libpq on macos
 brew install libpq
 bundle config --local build.pg --with-opt-dir="/usr/local/opt/libpq"
 bundle install

 # counting lines
 wc -l < /etc/passwd

 # getting size of file/folder
 du -sh Downloads

 # split bigger files in minor files, in this case 25000 lines in each one
 split -l 250000 safe_of_brafe.txt

 # backuping big data to .tar file
 pg_dump -U user -W -F t my_database_production > my_backup.tar

 # restoring big data from .tar file
 pg_restore -c -i -U user -d my_database_production -v "/tmp/client03.tar" -W

 # show dns trace routing
 dnstracer -s . -4 -o desconstruindoaweb.com.br

 # show tls cert details
 openssl s_client -connect desconstruindoaweb.com.br:443

 # configure ruby build before install older version on macos/rbenv
 export RUBY_CONFIGURE_OPTS="--with-openssl-dir=$(brew --prefix [email protected])"
 RUBY_CFLAGS=-DUSE_FFI_CLOSURE_ALLOC arch -arm64 rbenv install 2.4.10

 or

 export optflags="-Wno-error=implicit-function-declaration"
 RUBY_CFLAGS=-DUSE_FFI_CLOSURE_ALLOC rbenv install 2.4.2

 # install old gem

 LDFLAGS="-L/opt/homebrew/opt/libffi/lib" PKG_CONFIG_PATH="/opt/homebrew/opt/libffi/lib/pkgconfig" gem install ffi -v '1.9.18' -- --with-cflags="-Wno-error=implicit-function-declaration" 


 # Backup postgres docker
 docker run --rm --volumes-from cyberchecker_api-database-1 -v $(pwd):/backup postgres:12.3 tar cvf /backup/backup.tar /var/lib/postgresql/data

 # Restore backuped data postgres
 docker run --rm --volumes-from cyberchecker_api-database-1 -v $(pwd):/backup postgres:12.3 bash -c "cd /var/lib/postgresql/data && tar xvf /backup/backup.tar --strip 1"


 # run image id container on macos using platform linux
 docker run --rm --platform linux/amd64 -it --pull=never db0abf5d0472 /bin/bash
	#execute mariadb container
	sudo docker exec -it mariadb mysql -u root -p

	# importing data.sql to a database
	sudo docker exec -i mariadb mysql -uroot -proot database < data.sql

	# connect to postgres container
	docker exec -it postgres psql

	# setup postgres new user and db
	CREATE USER devandre WITH PASSWORD 'your_new_password';
	CREATE DATABASE dev_andre_development;
	GRANT ALL PRIVILEGES ON DATABASE dev_andre_development to devandre;
	ALTER DATABASE dev_andre_development OWNER TO devandre;

	# start postgres on macos
	pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

	# stop postgres on mac
	pg_ctl -D /usr/local/var/postgres stop -s -m fast

	# import data.sql to a database in postgres
	psql -U password_manager -d password_manager_production < data.sql

	# with docker
	sudo docker exec -i container_name /bin/bash -c "PGPASSWORD=pg_pass psql --username pg_user database_name" < data.sql

	# export data.sql from a database postgres container
	sudo docker exec -it container_name pg_dump -U user db_name > data.sql

	# export pg db
	pg_dump db_name > data_dump

	# execute mongodb container
	sudo docker exec -it mongodb mongo

	# create user on mongodb
	db.createUser({ user: 'devandre', pwd: 'my_password_1234', roles: [{ role: 'readWrite', db: 'dev_andre_development' }] })

	# kill any process on some port on linux
	sudo kill $(sudo lsof -t -i:3000)

	# change yout default terminal
	sudo update-alternatives --config x-terminal-emulator

	# copy to clipboard by terminal
	pbcopy < ~/.ssh/id_rsa.pub

	or

	grep "<keyword>" \| pbcopy


	# pasting from clipboard by terminal
	grep "<keyword>" \| tee myfile.txt

	# show terminal calendar
	cal

	# encrypting files on VIM
	:X

	# adding linux to platforms on gem lock
	bundle lock --add-platform x86_64-linux-musl

	# installing libpq on macos
	brew install libpq
	bundle config --local build.pg --with-opt-dir="/usr/local/opt/libpq"
	bundle install

	# counting lines
	wc -l < /etc/passwd

	# getting size of file/folder
	du -sh Downloads

	# split bigger files in minor files, in this case 25000 lines in each one
	split -l 250000 safe_of_brafe.txt

	# backuping big data to .tar file
	pg_dump -U user -W -F t my_database_production > my_backup.tar

	# restoring big data from .tar file
	pg_restore -c -i -U user -d my_database_production -v "/tmp/client03.tar" -W

	# show dns trace routing
	dnstracer -s . -4 -o desconstruindoaweb.com.br

	# show tls cert details
	openssl s_client -connect desconstruindoaweb.com.br:443

	# configure ruby build before install older version on macos/rbenv
	export RUBY_CONFIGURE_OPTS="--with-openssl-dir=$(brew --prefix [email protected])"
	RUBY_CFLAGS=-DUSE_FFI_CLOSURE_ALLOC arch -arm64 rbenv install 2.4.10

	or

	export optflags="-Wno-error=implicit-function-declaration"
	RUBY_CFLAGS=-DUSE_FFI_CLOSURE_ALLOC rbenv install 2.4.2

	# install old gem

	LDFLAGS="-L/opt/homebrew/opt/libffi/lib" PKG_CONFIG_PATH="/opt/homebrew/opt/libffi/lib/pkgconfig" gem install ffi -v '1.9.18' -- --with-cflags="-Wno-error=implicit-function-declaration"


	# Backup postgres docker
	docker run --rm --volumes-from cyberchecker_api-database-1 -v $(pwd):/backup postgres:12.3 tar cvf /backup/backup.tar /var/lib/postgresql/data

	# Restore backuped data postgres
	docker run --rm --volumes-from cyberchecker_api-database-1 -v $(pwd):/backup postgres:12.3 bash -c "cd /var/lib/postgresql/data && tar xvf /backup/backup.tar --strip 1"


	# run image id container on macos using platform linux
	docker run --rm --platform linux/amd64 -it --pull=never db0abf5d0472 /bin/bash
No results found