开发环境从MySQL 5.5.25 升级到 5.7.12
系统: Windows 7 32位
旧MySQL版本: mysql Ver 14.14 Distrib 5.5.25, for Win32 (x86)
新MySQL版本: mysql Ver 14.14 Distrib 5.7.12, for Win32 (AMD64)
使用mysqldump生成数据库备份SQL文件test.sql
java的Runtime.getRuntime().exec() 运行mysql -e “SOURCE test.sql” 还原数据库时报错
Mysql 5.7安装目录C:\Program Files\MySQL\MySQL Server 5.7\bin
在cmd窗口中执行运行是可以的,但是java执行“C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql” -e
同mysql --help的 返回内容 (原5.5不会出现该问题)
C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql Ver 14.14 Distrib 5.7.12, for
Win32 (AMD64)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Usage: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql [OPTIONS] [database]
解决方法:Runtime.getRuntime().exec() 执行两条cmd命令
cd /d "C:\Program Files\MySQL\MySQL Server 5.7\bin"
mysql -uroot -proot --port=3306 --host=127.0.0.1 -e "SOURCE C:\test.sql” -D test