Backup

String host,user,pw; 
............. 
............ 
File test=new File("c:test00.sql"); 
FileWriter fw=null; 
try { 
fw = new FileWriter(test); 
} 
catch (IOException ex) { 
} 
try{ 
Process child = rt.exec("mysqldump -h"+host+" -u"+user+" -p"+pw+" dump_test"); 

InputStream in = child.getInputStream(); 
InputStreamReader xx = new InputStreamReader(in,"latin1"); 
char[] chars=new char[1024]; 
int ibyte=0; 
while((ibyte=xx.read(chars))>0) 
{ 
fw.write(chars); 
} 
fw.close(); 

Hi, 

I am trying to perform a database backup using mysqldump through a java servlet, but it is not working... All suggestions greatly appreciated, as i need this done yesterday! 



try{ 
String line; 
String name = "portiadb"; 
String[] cmd2={"mysqldump", "--opt","portiadb"}; 
Process p=Runtime.getRuntime().exec(cmd2); 
p.waitFor(); 
DataInputStream input = new DataInputStream(p.getInputStream()); 

Vector theBytes = new Vector(500); // It will probably be far more 
boolean keepOn = true; 
while(keepOn) { 
byte b = input.readByte(); 
if(b == -1) 
keepOn = false; 
else 
theBytes.add(b); 
} 

theBytes.trimToSize(); 
byte [] output = new byte[theBytes.size()]; 
for(int i = 0; i < output.length; i++) { 
output[i] = theBytes.elementAt(i); 
} 

System.out.println(output); 
// It will be more useful to create a FileOutputStream, and write 'output' to the file. 

input.close(); 
} 
catch (Exception err) { 
err.printStackTrace(); 
out.println(err); 

}

// Este exemplo mostra como exibir um JFileChooser
// e escolher um arquivo a partir de uma aplicação
// console

import javax.swing.*;
import java.io.*;

public class EstudosFileChoser{
    public static void main(String[] args) {
        final JFileChooser fc = new JFileChooser();
        int res = fc.showOpenDialog(null);
        
        if(res == JFileChooser.APPROVE_OPTION){
          File arquivo = fc.getSelectedFile();  
          System.out.println("Voce escolheu o arquivo: " + arquivo.getName());
          	try{
            	File arquivo1 = new File("arquivo.getName()"); //File("C:\\java\\arquivo.getName()");
        		File arquivo2 = new File("C:\\java\\Meus_testes\\Exemplo2.java"); //Copiei para o diretorio
            	copiar(arquivo1, arquivo2);
            	System.out.println("O arquivo1 foi copiado para o arquivo2");
        	   }
            catch(IOException e)
            {
            // pode ocorrer erros
        	}

        }
        else
          System.out.println("Voce nao selecionou nenhum arquivo.");
    }
    
      	static void copiar(File fonte, File destino) throws IOException{
        InputStream in = new FileInputStream(fonte);
        OutputStream out = new FileOutputStream(destino);
    
        byte[] buf = new byte[1024];
        int len;
        while((len = in.read(buf)) > 0){
            out.write(buf, 0, len);
        }
        in.close();
        out.close();
    }

}

import java.io.BufferedOutputStream;

import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileWriter;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.text.SimpleDateFormat;

import java.util.Date;

*/

public class MyExec{

public static final int TAM_BUF = 4096;

public static final String COMMAND_LINE = "mysqldump -uroot -plalala --opt teste ";

public static final String TMP_DIR = “D://mysql//Bkps”;

public static final String SENHA = “lalalla”;

public static String data = new SimpleDateFormat(“yyyy-MM-dd_h-mm_a”).format(new Date());

public MyExec() {

super();

}

public static void main(String[] args) {
	MyExec my = new MyExec();
	
	my.run();
}

public void run()
{
	boolean result = true;
	try {  
		Process processReturn = Runtime.getRuntime().exec(COMMAND_LINE);
		if(processReturn != null){
			BufferedOutputStream bo = new BufferedOutputStream(processReturn.getOutputStream());
			bo.write(SENHA.getBytes());
			bo.close();
		}
		
		InputStream in = processReturn.getInputStream();
        if(in != null){
        	String arqResult = this.buildResult(in, "bkpTeste_"+data, new File(TMP_DIR).getAbsolutePath());
        	
        	if(result){
        		System.out.println("Backup executado com sucesso em " + arqResult);
        	}else{
        		System.out.println("Backup::executado com erro ! Resultado em arquivo "+arqResult);
        	}
        }      
		
	} catch (IOException e) {
		System.out.println("MyExec::run:exception "+e.toString());
	}
}  

public String buildResult(InputStream in, String nomeParcial, String tempDir)
{
	File flOut = null;
	BufferedWriter bw = null;
	BufferedReader br = null;
	char buff[] = new char[TAM_BUF];
	try {			
		flOut = File.createTempFile(nomeParcial, ".dmp", new File(tempDir));			
		bw = new BufferedWriter(new FileWriter(flOut));
		br = new BufferedReader(new InputStreamReader(in));
		int c;
		do{
			c = br.read(buff);
			if(c > 0){
				bw.write(buff,0,c);
			}
		}while(c > 0);
	} catch (Exception e) {
		System.out.println("MyExec::buildResult:exception "+e.toString());
	}
	finally{
		try {
			if(bw != null)
				bw.close();
			if(br != null)
				br.close();
		} catch (Exception e) {
			System.out.println("MyExec::buildResult:(close)exception "+e.toString());
		}
	}
	return(flOut.getAbsolutePath());
}