Nikita Pavets iamnnort

## mysql_workbench_utf8mb4.txt
# dump
/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --host=your_host --port=3306 --default-character-set=utf8mb4 --user=your_user --protocol=tcp -p your_database > dump.sql

# restore
/Applications/MySQLWorkbench.app/Contents/MacOS/mysql --host=your_host --port=3306 --default-character-set=utf8mb4 --user=your_user --protocol=tcp -p your_database < dump.sql

# when you see error "ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation"
From dump.sql file remove following lines:
-- SET @@SESSION.SQL_LOG_BIN= 0;
-- SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '';

## How to mimic componentDidUpdate() with React Hooks
const App = props => {
  const didMountRef = useRef(false)
  useEffect(() => {
    if (didMountRef.current) {
      doStuff()
    } else didMountRef.current = true
  }
}

## gist:03787cd0efe89bcabecc418538f4db8c
npm install -g win-node-env

## flex-super-center
.container {
  display: flex;
}

.box {
  flex: 1;
  display: flex;
  justify-content: center;
}

## git-tooltips.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                iamnnort
                / git-tooltips.md
            
            
              Created
              April 15, 2019 12:33
            
              
                Git tooltips
              
          
    git branch | grep -v "master" | xargs git branch -D - will delete all branches except master

  
## babel-polyfill.js
if (!global._babelPolyfill) {
  import 'babel-polyfill';
}

## docker-clean-all.sh
docker stop $(docker container ls -a -q) && docker system prune -a -f --volumes

## cli
- Start reindex
php bin/magento indexer:reindex

## Cross element
@mixin close($color, $size: 30px) {
  position: relative;

  display: inline-block;

  width: $size;
  height: $size;

  border: 0;


## Install Ubuntu
1.Install
sudo add-apt-repository ppa:gophers/archive
sudo apt update
sudo apt-get install golang-go
2. Insert path to ~/.bashrc
#Golang variables
export GOROOT=/usr/lib/go
export GOPATH=$HOME/go
export PATH=$PATH:$GOROOT/bin:$GOPATH/bin
3. Apply changes
	# dump
	/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --host=your_host --port=3306 --default-character-set=utf8mb4 --user=your_user --protocol=tcp -p your_database > dump.sql

	# restore
	/Applications/MySQLWorkbench.app/Contents/MacOS/mysql --host=your_host --port=3306 --default-character-set=utf8mb4 --user=your_user --protocol=tcp -p your_database < dump.sql

	# when you see error "ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation"
	From dump.sql file remove following lines:
	-- SET @@SESSION.SQL_LOG_BIN= 0;
	-- SET @@GLOBAL.GTID_PURGED=/!80000 '+'/ '';
	const App = props => {
	const didMountRef = useRef(false)
	useEffect(() => {
	if (didMountRef.current) {
	doStuff()
	} else didMountRef.current = true
	}
	}
	.container {
	display: flex;
	}

	.box {
	flex: 1;
	display: flex;
	justify-content: center;
	}
	@mixin close($color, $size: 30px) {
	position: relative;

	display: inline-block;

	width: $size;
	height: $size;

	border: 0;
	1.Install
	sudo add-apt-repository ppa:gophers/archive
	sudo apt update
	sudo apt-get install golang-go
	2. Insert path to ~/.bashrc
	#Golang variables
	export GOROOT=/usr/lib/go
	export GOPATH=$HOME/go
	export PATH=$PATH:$GOROOT/bin:$GOPATH/bin
	3. Apply changes