Member Avatar for cretaros

I want to dump or backup a mysql database on button click, i have the following logic, no errors bt it cant execute, can anyone help me in identifying the error. the code as follows:

try {
                     
                        String dbName = "xxx";
                        String dbUser = "root";
                        String dbPass = "";
                     
                     
                        String excecuteCmd = "";
                     
                        excecuteCmd = "/C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqldump.exe  -u" + dbUser + " -p"+ dbPass + "" + dbName+" > xxxdb_bckp.sql";
                     
                        Process runtimeProcess = Runtime.getRuntime().exec(excecuteCmd);
                     
                        int processComplete = runtimeProcess.waitFor();
                     
                     
                        if(processComplete == 0) 
                        {
                           JOptionPane.showMessageDialog(null, "Backup Succesful");
                        
                        }
                        
                        else  
                        {
                            
                           JOptionPane.showMessageDialog(null, "Backup Failed");
                        
                        } 
                     }
                         catch(Exception expn)
                        {
                           JOptionPane.showMessageDialog(null, expn);
                        
                        }

it notifies that backup failed.

  • 2 Contributors
  • 1 Reply
  • 189 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by mKorbel
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.