Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static String ip = "localhost";
- private static String port = "3306";
- private static String database = "IMS";
- private static String user = "root";
- private static String pass = "pass";
- private static String path = "/home/user/Desktop/project/";
- public static void backup() {
- Date dateNow = new Date();
- SimpleDateFormat dateformatyyyyMMdd = new SimpleDateFormat("yyyyMMdd");
- String date_to_string = dateformatyyyyMMdd.format(dateNow);
- System.out.println("date into yyyyMMdd format: " + date_to_string);
- String ss = "IMS.sql";
- String fullName = path + " " + date_to_string + " " + ss;
- String dumpCommand = "mysqldump " + database + " -h " + ip + " -u " + user + " -p" + pass;
- Runtime rt = Runtime.getRuntime();
- File test = new File(fullName);
- PrintStream ps;
- try {
- Process child = rt.exec(dumpCommand);
- ps = new PrintStream(test);
- InputStream in = child.getInputStream();
- int ch;
- while ((ch = in.read()) != -1) {
- ps.write(ch);
- //System.out.write(ch); //to view it by console
- }
- InputStream err = child.getErrorStream();
- while ((ch = err.read()) != -1) {
- System.out.write(ch);
- }
- } catch (Exception exc) {
- exc.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement