How to use java MySql database backup and recovery procedures?

Jul 29 posted in Database (RSS), comments.

Advertisements

How to use java MySql database backup and recovery procedures?
Note: To add to the mysql bin directory in the Path environment variable

MySql database will be exported to a file backup

import java.io. *;
import java.lang .*;

public class BeiFen {

public static void main (String [] args) {
/ / Database Export
String user = "root"; / / database account
String password = "root"; / / login password
String database = "test"; / / need to back up the database name
String filepath = "e: \ \ test.sql"; / / address of the backup path

String stmt1 = "D: \ \ mysql5027 \ \ bin \ \ mysqldump" + database + "-u" + user + "-p"
+ Password + "- result-file =" + filepath;

/ *
* String stmt1 = "mysqldump" + database + "-u" + user + "-p"
* + Password + "- result-file =" + filepath;
*
* String mysql = "mysqldump test-u root-proot
* - Result-file = d: \ \ test.sql ";
* /

try {
Runtime.getRuntime (). Exec (stmt1);
System.out.println ("data has been exported to file" + filepath + "in");
}
catch (IOException e) {
e.printStackTrace ();
}
}
}

Data from a text file on the disk to restore the database to MySql

import java.io. *;
import java.lang .*;

/ *
* Restoring MySql database
* * /
public class Recover {

public static void main (String [] args) {

String filepath = "d: \ \ test.sql"; / / address of the backup path
/ / Create database test

String stmt1 = "mysqladmin-u root-proot create test";

String stmt2 = "mysql-u root-proot test <" + filepath;
String [] cmd = {"cmd", "/ c", stmt2};

try {
Runtime.getRuntime (). Exec (stmt1);
Runtime.getRuntime (). Exec (cmd);
System.out.println ("data from" + filepath + "into the database");
} Catch (IOException e) {
e.printStackTrace ();
}
}
}

Another program

package jakie;

/ / Import java.io. *;

public class Backup {
private String user_name; / / database user name
private String user_psw; / / database password
private String db_name; / / need to back up the database name
private String host_ip;
private String user_charset;
private String backup_path; / / store the backup file path
private String stmt;

public Backup (String user_name, String user_psw, String db_name, String host_ip, String user_charset, String backup_path) {
this.user_name = user_name;
this.user_psw = user_psw;
this.db_name = db_name;
/ / Host IP;
if (host_ip == null | | host_ip.equals (""))
this.host_ip = "localhost"; / / default to native
else
this.host_ip = host_ip;
/ / Character set
if (user_charset == null | | user_charset.equals (""))
this.user_charset = ""; / / default to set the character set installed
else
this.user_charset = "- default-character-set =" + user_charset;
this.backup_path = backup_path;

this.stmt = "d: \ \ MYSQL \ \ bin \ \ mysqldump" + this.db_name + "-h" + this.host_ip + "-u" + this.user_name + "-p" + this.user_psw
+ This.user_charset + "- result-file =" + this.backup_path;
}

public boolean backup_run () {
boolean run_result = false;
try {
Runtime.getRuntime (). Exec (this.stmt);
run_result = true;
} Catch (Exception e) {
e.printStackTrace ();
} Finally {
return run_result;
}
}
public static void main (String [] args) {
Backup backup = new Backup ("root", "000000", "jakie", null, "utf8", "e: \ \ test.sql");
boolean result = backup.backup_run ();
if (result)
System.out.println ("Backup successful");

}
}