如何使用Java恢复MySQL数据库备份 [英] How to restore a MySQL database backup using Java
问题描述
在以下Java代码的帮助下,我可以使用 mysqldump.exe 以.SQL 文件的形式创建当前mysql数据库的备份.
I was able to create a backup of my current mysql database as .SQL file using the mysqldump.exe with the help of the following java code.
Process runProcess = Runtime.getRuntime().exec("C:\\SCM Files\\SQL Backup\\mysqldump.exe -uroot -p123 rr -r\"C:\\SCM Files\\SQL Backup\\RR.sql");
现在,我想使用与上面类似的Java 代码将相同的.SQL Backup 文件恢复到mysql数据库,如果单击了按钮,则与上面类似.
Now I want to restore this same .SQL Backup file to mysql database using java code similar to above on the event of a button clicked.
非常感谢:)
所以现在我尝试了这个;
Process runProcess = Runtime.getRuntime().exec("C:\\SCM Files\\SQL Backup\\mysqldump.exe -uroot -p123 rr < C:\\SCM Files\\SQL Backup\\RR.sql");
仍然不起作用:/
So now I tried this ;
Process runProcess = Runtime.getRuntime().exec("C:\\SCM Files\\SQL Backup\\mysqldump.exe -uroot -p123 rr < C:\\SCM Files\\SQL Backup\\RR.sql");
Still it didn't work :/
推荐答案
Runtime.getRuntime().exec("mysql -u username -ppassword database_name FILE.sql")
此语句将从文件中重新生成数据库
This statement will regenerate database from the file
这篇关于如何使用Java恢复MySQL数据库备份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!