SQL import using Java

Question

I have tried to export and import the data base in my java project.But the execute command doesnt work. Following is the code I've done.

    public boolean exportDatabase(String fromServer, String FileName, String FilePath, int ExportOpions)
    {

        try {
            Class.forName(Driver).newInstance();
        }
        catch (final InstantiationException e) {
            NLogger.writeDebugLog(e);
        }
        catch (final IllegalAccessException e) {
            NLogger.writeDebugLog(e);
        }
        catch (final java.lang.ClassNotFoundException e) {
        NLogger.writeDebugLog(e);
    }
    try {

        String dbName ="DBsample";
        String dbUser = "root";
        String dbPass ="root";


        String executeCmd ="CD "+FilePath+" mysqldump -u "+dbUser+ "-p"+dbPass+" "+dbName+ ">" +FileName;

        Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);
        int processComplete = runtimeProcess.waitFor();
        if(processComplete == 0){
        System.out.println("Backup taken successfully");
        } 
        else {
        System.out.println("Could not take mysql backup");
        }
    return true;
    }
    catch (final Exception ex) {
        NLogger.writeErrorLog("Database Connection Failed ", ex.toString());
        NLogger.writeDebugLog(ex);
        return false;
    }

}

This shows an error as

"Cannot run program "CD": CreateProcess error=2, The system cannot find the file specified"

How can I solve this issue?

mysqldump is for exporting, am i right?

gumuruh
– gumuruh

2019-04-02 10:55:09 +00:00
Commented Apr 2, 2019 at 10:55 — gumuruh
– gumuruh, Commented Apr 2, 2019 at 10:55

Nandkumar Tekale · Accepted Answer · 2012-09-06 10:04:19Z

2

If you are running command then, you need to prepend "cmd" to your_command_to_be_run.

Make it as :

String executeCmd ="cmd CD "+FilePath+" mysqldump -u "+dbUser+ "-p"+dbPass+" "+dbName+ ">" +FileName;

Also I do not know command to export, but it seems your command is wrong. You should directly specify directory. You are using cd in your command. Consider following example :

C:\mydir1\mydir2\some.exe   // this is correct
cmd cd C:\mydir1\mydir2 some.exe   // this is wrong

edited Sep 6, 2012 at 10:04

answered Sep 6, 2012 at 9:55

Nandkumar Tekale

16.2k8 gold badges60 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nandkumar Tekale Over a year ago

@Gapchoos this address? can you be more clear what you want to do?

Seki · Accepted Answer · 2012-09-06 11:04:36Z

1

first set System Variable like

C:\Program Files\MySQL\MySQL Server 5.1\bin;

then

String executeCmd = mysqldump -u "+dbUser+ "-p"+dbPass+" "+dbName+ ">" +FileName;

edited Sep 6, 2012 at 11:04

Seki

11.5k7 gold badges49 silver badges74 bronze badges

answered Sep 6, 2012 at 10:06

Dipul Patel

1876 bronze badges

Comments

Ketan Bhavsar · Accepted Answer · 2012-09-06 09:59:55Z

0

Try this....

String executeCmd ="FilePath+" mysqldump -u "+dbUser+ "-p"+dbPass+" "+dbName+ ">" +FileName;

answered Sep 6, 2012 at 9:59

Ketan Bhavsar

5,41610 gold badges40 silver badges70 bronze badges

Comments

reto · Accepted Answer · 2012-10-01 16:19:55Z

0

you can try this way:

try {
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

    conn = DriverManager.getConnection(DbConnectionAdress, DbName, DbSifre);
    statement = conn.createStatement();
} catch (Exception e) {
    throw new RuntimeException(e);
}

String DbConnectionAdress = " "

DbName = ""

DbSifre = ""

edited Oct 1, 2012 at 16:19

reto

16.8k8 gold badges56 silver badges70 bronze badges

answered Sep 6, 2012 at 9:59

hakanpekcan

1

1 Comment

reto Over a year ago

hakanpekcan: never ever have an 'catch-all' exception handler without any exception handling. Thats very bad style and can (and will) cause great confusion! I will edit in a fix for that.

Collectives™ on Stack Overflow

SQL import using Java

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related