Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <RUTA_DE_MYSQL>mysqldump --opt --password=<CONTRASEÑA> --user=root <BASE_DE_DATOS> > <RUTA_DE_DESTINO>Backup.sql
- private static void backup() {
- //Carpeta que contendra el Backup:
- File carpeta = new File(<RUTA_CONTENEDORA_BACKUP>);
- carpeta.mkdirs();
- //*
- //Creacion del .sql
- Runtime runtime = Runtime.getRuntime();
- File backup = new File(<RUTA_CONTENEDORA_BACKUP> + "\Backup.sql");
- try {
- InputStreamReader isr;
- BufferedReader br;
- FileWriter fileWriterGeneral = new FileWriter(backup);
- Process child = runtime.exec("<RUTA_DE_MYSQL>\mysqldump --opt --user=root --password=<CONTRASEÑA>--databases <CONTRASEÑA> -R");
- isr = new InputStreamReader(child.getInputStream());
- br = new BufferedReader(isr);
- //*
- //Pasar todo al .sql
- String line;
- while ((line = br.readLine()) != null) {
- fileWriterGeneral.write(line + " n");
- }
- isr.close();
- br.close();
- } catch (IOException e) {
- e.printStackTrace();
- }
- }
- -- Dump completed on <FECHA_DEL_BACKUP> <HORA_DEL_BACKUP>
- //Pasar todo al .sql
- String line;
- while ((line = br.readLine()) != null) {
- System.out.println(line);
- fileWriterGeneral.write(line + " n");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement