Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Runtime runtime = Runtime.getRuntime();
- runtime.exec("C:\Program Files\MySql\MySql Server 5.5\bin\mysqldump -u root -p myDatabase> D:\backup.sql");
- runtime.exec(new String[]{"C:\Program Files\MySql\MySql Server 5.5\bin\mysqldump", "-u", "root", "-pmyDatabase" "> D:\backup.sql"});
- /******************************************************/
- //Database Properties
- /******************************************************/
- String dbName = “dbName”;
- String dbUser = “dbUser”;
- String dbPass = “dbPass”;
- /***********************************************************/
- // Execute Shell Command
- /***********************************************************/
- String executeCmd = “”;
- executeCmd = “mysqldump -u “+dbUser+” -p”+dbPass+” “+dbName+” -r backup.sql”;
- }
- Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);
- int processComplete = runtimeProcess.waitFor();
- if(processComplete == 0){
- out.println(“Backup taken successfully”);
- } else {
- out.println(“Could not take mysql backup”);
- }
- /******************************************************/
- //Database Properties
- /******************************************************/
- String dbName = “dbName”;
- String dbUser = “dbUser”;
- String dbPass = “dbPass”;
- /***********************************************************/
- // Execute Shell Command
- /***********************************************************/
- String executeCmd = “”;
- executeCmd = new String[]{“/bin/sh”, “-c”, “mysql -u” + dbUser+ ” -p”+dbPass+” ” + dbName+ ” < backup.sql” };
- }
- Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);
- int processComplete = runtimeProcess.waitFor();
- if(processComplete == 0){
- out.println(“success”);
- } else {
- out.println(“restore failure”);
- }
- public void actionPerformed(ActionEvent evt)
- {
- private String m_MySqlPath="";
- ResultSet res=null;
- res = DBHandler.getInstance().executeQuery("select @@basedir",null);
- while(res.next())
- {
- m_MySqlPath=res.getString(1) ;
- }
- m_MySqlPath = m_MySqlPath.replace("\Data\", "\bin\");
- if (exportDB.isSelected()
- {
- try {
- String executeCmd = m_MySqlPath + "\mysqldump -u " + DB_USER
- +" -p" + DB_PASSWORD + " " + DB_NAME + " -r " + """+FilePath + "\"
- + FileName+""";
- Process runtimeProcess = Runtime.getRuntime().exec(executeCmd, null);
- BufferedReader r=new BufferedReader(new InputStreamReader(runtimeProcess.getInputStream()));
- String s;
- while((s=r.readLine())!=null)
- {
- System.out.println(s);
- }
- return true;
- }
- catch (final Exception ex) {
- ex.printstackTrace();
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement