http://firebody.blogbus.com/logs/2004/08/355958.html
本來也想弄這樣的咚咚!javaeye論壇剛好有人貼出來,我就轉(zhuǎn)過來,以做個(gè)記錄!
數(shù)據(jù)庫導(dǎo)出
String path="mysqldump.exe -uuser -ppwd --opt databasename > d:/databack/xx.sql";
java.lang.Runtime.getRuntime().exec("cmd /c "+path);
System.out.println("數(shù)據(jù)表已導(dǎo)出到文件xx.sql中");
//數(shù)據(jù)庫導(dǎo)入
String path="mysqladmin -uroot -p create databasename";
java.lang.Runtime.getRuntime().exec("cmd /c "+path);
path="mysql databasename < d:/databack/xx.sql";
java.lang.Runtime.getRuntime().exec("cmd /c "+path);
System.out.println("數(shù)據(jù)表已從文件xx.sql中導(dǎo)入");