Diogo Zarpelon zarpelon

👨‍💻

Simplicity is the essence of happiness. - Cedric Bledsoe

zarpelon / docker-mysql-backup-restore.sh

Created September 11, 2021 16:03

Docker MySQL - Backup and Restore

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

zarpelon / git-aliases.txt

Last active July 12, 2022 19:30

Git-aliases

	git config --global alias.st status
	git config --global alias.ci commit
	git config --global alias.co checkout
	git config --global alias.br branch
	git config --global alias.pom = push origin master
	git config --global alias.plom = pull origin master
	git config --global color.ui auto

zarpelon / gist:f43ded9123365e9d4a9ff0139baa137f

Created December 18, 2020 13:46

SqlSrv on PHP 7.4 and Ubuntu 20.04

	sudo apt update
	sudo apt install php-pear php-dev
	curl -s https://packages.microsoft.com/keys/microsoft.asc \| sudo apt-key add -
	sudo bash -c "curl -s https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list"
	sudo apt update
	sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
	sudo apt -y install unixodbc-dev
	sudo apt -y install gcc g++ make autoconf libc-dev pkg-config
	sudo pecl install sqlsrv
	sudo pecl install pdo_sqlsrv

zarpelon / gist:cf9dc6b7c404e34cdb1ad5320f9fcab8

Created April 2, 2020 20:20

git:alias-hist

	##
	# Creates an alias called "git hist" that outputs a nicely formatted git log.
	# Usage is just like "git log"
	# Examples:
	# git hist
	# git hist -5
	# git hist <branch_name>
	# git hist <tag_name> -10
	##
	git config --global alias.hist "log --pretty=format:'%C(yellow)[%ad]%C(reset) %C(green)[%h]%C(reset) \| %C(red)%s %C(bold red){{%an}}%C(reset) %C(blue)%d%C(reset)' --graph --date=short"

zarpelon / pg-dump-restore

Last active March 24, 2021 13:53

PG Dump/Restore

	PostgreSQL database server provides pg_dump and psql utilities for backup and restore databases. This article will describe various ways to use of pg_dump command to backup database. Also you will learn how to restore datbase backup.

	Backup and Restore Database in PostgreSQL
	Below is some connections options which you can use for connecting remote server or authenticated server with all queries given in this article.

	-d, –dbname=DBNAME database name
	-h, –host=HOSTNAME database server hostname or ip
	-p, –port=PORT database server port number (default: 5432)
	-U, –username=NAME connect as specified database user
	-W, –password force password prompt