Advertisement
Guest User

Untitled

a guest
Mar 17th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. <RUTA_DE_MYSQL>mysqldump --opt --password=<CONTRASEÑA> --user=root <BASE_DE_DATOS> > <RUTA_DE_DESTINO>Backup.sql
  2.  
  3. private static void backup() {
  4. //Carpeta que contendra el Backup:
  5. File carpeta = new File(<RUTA_CONTENEDORA_BACKUP>);
  6. carpeta.mkdirs();
  7. //*
  8. //Creacion del .sql
  9. Runtime runtime = Runtime.getRuntime();
  10. File backup = new File(<RUTA_CONTENEDORA_BACKUP> + "\Backup.sql");
  11. try {
  12. InputStreamReader isr;
  13. BufferedReader br;
  14. FileWriter fileWriterGeneral = new FileWriter(backup);
  15. Process child = runtime.exec("<RUTA_DE_MYSQL>\mysqldump --opt --user=root --password=<CONTRASEÑA>--databases <CONTRASEÑA> -R");
  16. isr = new InputStreamReader(child.getInputStream());
  17. br = new BufferedReader(isr);
  18. //*
  19. //Pasar todo al .sql
  20. String line;
  21. while ((line = br.readLine()) != null) {
  22. fileWriterGeneral.write(line + " n");
  23. }
  24. isr.close();
  25. br.close();
  26. } catch (IOException e) {
  27. e.printStackTrace();
  28. }
  29. }
  30.  
  31. -- Dump completed on <FECHA_DEL_BACKUP> <HORA_DEL_BACKUP>
  32.  
  33. //Pasar todo al .sql
  34. String line;
  35. while ((line = br.readLine()) != null) {
  36. System.out.println(line);
  37. fileWriterGeneral.write(line + " n");
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement