Java implementation MySQL database backup (ii)

Rights statement: This article for Bo Master original article, without Bo Master permission not reproduced.

Blog "Java implementation MySQL database backup (i)" using I/O stream to implement the MySQL database backup, this method is more complicated, the following describes another way to back up the MySQL database:

[Java]View PlainCopy

2. Import Java.io.File;
4. Import java.io.IOException;
8. /**
10. * MySQL Database backup
12. *
14. * @author Gaohuanjie
16. */
18. Public class Mysqldatabasebackup {
22. /** 
24. * Java code Implementation MySQL database export
26. *
28. * @author Gaohuanjie
30. * @param hostip MySQL database is located on the server address IP
32. * @param userName User name required to enter the database
34. * @param password The password required to enter the database
36. * @param savepath Database Export File save path
38. * @param filename Export file name of the filename database
40. * @param databaseName The name of the database to be exported
42. * @return returns True to indicate that the export was successful, otherwise false.
44. */
46. public Static boolean Exportdatabasetool (String HostIP, String userName, string password, string savepath, St Ring FileName, String databaseName) {
48. File SaveFile = new File (Savepath);
50. if (!savefile.exists ()) {//If the directory does not exist
52. Savefile.mkdirs (); //Create a folder
54. }
56. if (!savepath.endswith (File.separator)) {
58. Savepath = Savepath + file.separator;
60. }
64. StringBuilder StringBuilder = new StringBuilder ();
66. Stringbuilder.append ("mysqldump"). Append ("--opt"). Append ("-H").append (HostIP);
68. Stringbuilder.append ("--user="). Append (UserName). Append ("--password="). Append (password). Append ("--  Lock-all-tables=true ");
70. Stringbuilder.append ("--result-file="). Append (Savepath + fileName). Append ("--default-character-set=utf8"  ). append (DatabaseName);
72. try {
74. Process process = Runtime.getruntime (). EXEC (stringbuilder.tostring ());
76. if (process.waitfor () = = 0) {//0 indicates normal termination of the thread.
78. return true;
80. }
82. } catch (IOException e) {
84. E.printstacktrace ();
86. } catch (Interruptedexception e) {
88. E.printstacktrace ();
90. }
92. return false;
94. }
98. public static void Main (string[] args) throws interruptedexception {
100. if (Exportdatabasetool ("172.16.0.127", "root", " 123456", "D:/backupdatabase", "2014-10-14.") SQL ", " test ")) {
102. SYSTEM.OUT.PRINTLN ("database backup succeeded!!!  ");
104. } Else {
106. SYSTEM.OUT.PRINTLN ("Database backup failed!!!  ");
108. }
110. }
112. }

Java implementation MySQL database backup (ii)