[MySQL] MAC에서 DataGrip에 dump 연동하기

MySQL과 Workbench 설치

# Install
brew install mysql@5.7
brew install mysql-client
brew install mysqlworkbench


# Symbol link
sudo ln -s /Applications/MySQLWorkbench.app/Contents/MacOS/mysql /usr/local/bin/mysql
sudo ln -s /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump /usr/local/bin/mysqldump

 

DataGrip mysqldump 할 때, out path 밑 input에 '--column-statistics=0' 추가

"database_name" --result-file="/Users/{user}/{data_source}-{timestamp}-dump.sql" --column-statistics=0