导出导入数据库

导出所有数据库

mysqldump -u root -p --host=127.0.0.1 --all-databases > all_dump.sql

导入所有数据库

mysql -u root -p --host=127.0.0.1 < all_dump.sql

数据库免费软件

  1. dbeaver-community
brew install --cask dbeaver-community

https://formulae.brew.sh/cask/dbeaver-community

  1. navicat-premium-lite
brew install --cask navicat-premium-lite

https://formulae.brew.sh/cask/navicat-premium-lite