Back up MySQL databases by calling Java commands

Back up MySQL databases by calling Java commands

Java code

1. String command = "CMD/C:/program files/MySQL Server 5.0/bin> mysqldump-H localhost-u root-P aijia> E:/aijia. dmp ";
2. Try {
3. Process = runtime.getruntime(cmd.exe C (command );
4. Inputstreamreader IR = new inputstreamreader (Process
5. . Getinputstream ());
6. Linenumberreader input = new linenumberreader (IR );
7. String line;
8. While (line = input. Readline ())! = NULL)
9. System. Out. println (line );
10. Input. Close ();
11. } Catch (ioexception e ){
12. E. printstacktrace ();
13. }
18. In addition
20. First, set the MySQL environment variable (add % mysql_home %/bin in path) and restart the computer.
21. Complete code:
22. /**
23. * @ Param ARGs
24. */
25. Public static void main (string [] ARGs ){
26. /*
27. * Backup and import are reciprocal processes.
28. * Backup: The program calls the MySQL BACKUP command to read the console input stream information and write the. SQL file;
29. * Import: The program calls the MySQL import command to write the Information read from the. SQL file to the output stream on the console.
30. * Note: ">" and "<" are unavailable at this time.
31. */
32. Backup ();
33. Load ();
34. }
36. /**
37. * Check whether an SQL file can be used as an import file through backup: use Notepad and Ultra to separate the SQL file.
38. * Edit is enabled. If no garbled characters are displayed in Chinese, the source file can be used for import (regardless of the encoding format of the SQL file or the DB encoding format)
39. */
40. Public static void backup (){
41. Try {
42. Runtime RT = runtime. getruntime ();
44. // Call the CMD of MySQL:
45. Process child = RT
46. . Exec ("mysqldump-u root -- Set-charset = utf8 bjse act_obj"); // set the export encoding to utf8. It must be utf8.
48. // Write the console output information in the process execution to the. SQL file, which generates a backup file. Note: If you do not read the console information, the process may be blocked and cannot run.
49. Inputstream in = Child. getinputstream (); // the output information of the console is used as the input stream.
51. Inputstreamreader xx = new inputstreamreader (in, "utf8"); // sets the output stream encoding to utf8. This must be utf8; otherwise, garbled characters are read from the stream.
53. String instr;
54. Stringbuffer sb = new stringbuffer ("");
55. String outstr;
56. // Combine the console output string
57. Bufferedreader BR = new bufferedreader (XX );
58. While (instr = Br. Readline ())! = NULL ){
59. SB. append (instr + "/R/N ");
60. }
61. Outstr = sb. tostring ();
63. // The SQL target file to be used for import:
64. Fileoutputstream fout = new fileoutputstream (
65. "E:/mysql-5.0.27-win32/bin/bjse22. SQL ");
66. Outputstreamwriter writer = new outputstreamwriter (fout, "utf8 ");
67. Writer. Write (outstr );
68. // Note: if the file is written as a buffer, Chinese characters may be garbled. You can avoid using the flush () method.
69. Writer. Flush ();
71. // Do not forget to close the input/output stream
72. In. Close ();
73. XX. Close ();
74. BR. Close ();
75. Writer. Close ();
76. Fout. Close ();
78. System. Out. println ("/* output OK! */");
80. } Catch (exception e ){
81. E. printstacktrace ();
82. }
84. }
86. /**
87. * Import
88. *
89. */
90. Public static void load (){
91. Try {
92. String fpath = "E:/mysql-5.0.27-win32/bin/bjse22. SQL ";
93. Runtime RT = runtime. getruntime ();
95. // Call the CMD of MySQL:
96. Process child = rt.exe C ("mysql-u root bjse ");
97. Outputstream out = Child. getoutputstream (); // the input information of the console is used as the output stream.
98. String instr;
99. Stringbuffer sb = new stringbuffer ("");
100. String outstr;
101. Bufferedreader BR = new bufferedreader (New inputstreamreader (
102. New fileinputstream (fpath), "utf8 "));
103. While (instr = Br. Readline ())! = NULL ){
104. SB. append (instr + "/R/N ");
105. }
106. Outstr = sb. tostring ();
108. Outputstreamwriter writer = new outputstreamwriter (Out, "utf8 ");
109. Writer. Write (outstr );
110. // Note: if the file is written as a buffer, Chinese characters may be garbled. You can avoid using the flush () method.
111. Writer. Flush ();
112. // Do not forget to close the input/output stream
113. Out. Close ();
114. BR. Close ();
115. Writer. Close ();
117. System. Out. println ("/* load OK! */");
119. } Catch (exception e ){
120. E. printstacktrace ();
121. }
123. }