1: mysqldump --all-database
2: 删掉mysql:
- 使用mysqldump备份你的数据库将文本文件!
- 停止数据库服务器 sudo /usr/local/mysql/support-files/mysql.server stop
- sudo rm /usr/local/mysql
- sudo rm -rf /usr/local/mysql*
- sudo rm -rf /Library/StartupItems/MySQLCOM
- sudo rm -rf /Library/PreferencePanes/My*
- edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
- rm -rf ~/Library/PreferencePanes/My*
- sudo rm -rf /Library/Receipts/mysql*
- sudo rm -rf /Library/Receipts/MySQL*
- sudo rm -rf /private/var/db/receipts/*mysql*
3: 5.7 中没有 utf8mb4_0900_ai_ci
==》 utf8mb4_0900_ai_ci 替换为:utf8_general_ci
2:
mysql 5.7 Storage engine 'InnoDB' does not support system tables. [mysql.columns_priv]
将 系统表的sql 删掉,值保留业务表,原dump文件的头尾保留