mysql5.1升级到mysql5.7

Q：mysql5.1升级到mysql5.7
A：请如下操作
1、docs命名进入到5.1数据库的bin目录下


2、用sql导出数据库的数据，命令如下
//--port=3307 端口号
//F:\share\backup\obpm.sql 为导出位置
D:\mysql-5.1.14-win32\bin>mysqldump  -uroot --port=3307 --default-character-set=utf8 obpm >F:\share\backup\obpm.sql
D:\mysql-5.1.14-win32\bin>mysqldump  -uroot --port=3307 --default-character-set=utf8 obpm_oa >F:\share\backup\obpm_oa.sql
D:\mysql-5.1.14-win32\bin>mysqldump  -uroot --port=3307 --default-character-set=utf8 obpm_crm_new >F:\share\backup\obpm_crm_new.sql


3、停止mysql5.1的服务，卸载mysql数据库的服务
输入命令 MySQL-OBPM-Port-3307


4、docs命令进入到5.7数据库的bin目录下，并用sql导入5.1备份的数据
C:\WINDOWS\system32>cd /d D:\mysql-5.7.14-win32\bin
D:\mysql-5.7.14-win32\bin>mysql -h localhost -u root --port=3308 --default-character-set=utf8 obpm < F:\share\backup\obpm.sql

D:\mysql-5.7.14-win32\bin>mysql -h localhost -u root --port=3308 --default-character-set=utf8 obpm_oa < F:\share\backup\obpm_oa.sql
D:\mysql-5.7.14-win32\bin>mysql -h localhost -u root --port=3308 --default-character-set=utf8 obpm_crm_new < F:\share\backup\obpm_crm_new.sql

5、用sql更新导入到5.7的数据
C:\WINDOWS\system32>cd /d D:\mysql-5.7.14-win32\bin

D:\mysql-5.7.14-win32\bin>mysql_upgrade -u root --force --port=3307