Creating MySql Backup With Java In Linux

Question

I am using this java class to create and restore MySql backup of 'tcs' database , what should i add or edit in this code to create and restore MySql backup in linux?

import java.io.File;

public class NastyDbJobs {

    private static String dbName = "tcs";
    private static String dbUserName = "root";
    private static String dbPassword = "password";

    public static boolean backupDB(File file) {
        String path = file.getPath();

        if (!path.contains(".sql")) {
            file = new File(path + ".sql");
        }

        String executeCmd = "mysqldump -u " + dbUserName + " -p" + dbPassword + " --add-drop-database -B " + dbName + " -r " + file.getPath();
        Process runtimeProcess;
        try {

            runtimeProcess = Runtime.getRuntime().exec(executeCmd);
            int processComplete = runtimeProcess.waitFor();

            if (processComplete == 0) {
                System.out.println("Backup created successfully");
                runtimeProcess.destroy();
                return true;
            } else {

                System.out.println("Could not create the backup");
            }


        } catch (Exception ex) {
            ex.printStackTrace();


        }

        return false;
    }

    public static boolean restoreDB(File file) {
        String path = file.getPath();
        if (!path.contains(".sql")) {
            file = new File(path + ".sql");
        }

        String[] executeCmd = new String[]{"mysql", "--user=" + dbUserName, "--password=" + dbPassword, "-e", "source " + file.getPath()};

        Process runtimeProcess;
        try {

            runtimeProcess = Runtime.getRuntime().exec(executeCmd);
            int processComplete = runtimeProcess.waitFor();

            if (processComplete == 0) {
                System.out.println("Backup restored successfully");
                return true;
            } else {
                System.out.println("Could not restore the backup");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return false;
    }
}

What do you mean for linux? If it already saves and restores just fine, it should be cross compatible for all os's — greedybuddha, Jun 02 '13 at 15:42
I see, I didn't notice you were using commands to do the mysqldump. try this http://stackoverflow.com/questions/9567699/how-to-mysqldump-on-java — greedybuddha, Jun 02 '13 at 15:44

score 1 · Answer 1 · answered Jan 12 '16 at 05:49

import java.io.File;
import java.io.InputStream;
import java.io.PrintStream;
import java.util.*;

import java.util.Date;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
public class TableBackup_1 {

private static String ip="localhost";
private static String port="3306";
private static String database="xyz";
private static String user="root";
private static String pass="pass";
private static String path="/home/Admin/abc/";
public static void export()
{
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="abc.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();
}
}

public static void main(String args[]){
export();
}
}

Could you explain a bit about what this does and how it answers the question? — David Maust, Jan 12 '16 at 05:55
Tried this code with some adjustments on my EE application in tomcat server. It's perfectly working :) — Chamithra Thenuwara, Jun 02 '16 at 04:24

score 0 · Answer 2 · answered Jun 03 '13 at 09:23

0

You will have to have some kind of ini/ Properties file/ data base value that points to the full path of mysqldump unless its in your path variable. Then replace mysqldump with the full path

"/myPath/mysql5/mysqldump"

or

"c:\\myPath\\mysql5\\mysqldump"

then in the exec command first parameter pass the full path to the systems mysqldump application

answered Jun 03 '13 at 09:23

tgkprog

4,493
4
41
70

you mean i can use exec in linux too? – MoienGK Jun 03 '13 at 10:38
yes but the command to execute might be different so load that from a file so you can change it without the need to recompile your code. ofcourse the ini file should be safe guarded. – tgkprog Jun 03 '13 at 12:03

Creating MySql Backup With Java In Linux

2 Answers2