sergio_educacionit

volcado recurrete bases datos

Aug 23rd, 2025
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. dir="/home/educacionit/bases_datos"
  4.  
  5.  
  6. # crear un array con todas las bases de datos
  7.  
  8. databases=( $(mysql -N -s -e "SHOW DATABASES;") )
  9. excludes=( "information_schema" "performance_schema" "sys" )
  10.  
  11.  
  12.  
  13.  
  14. for db in ${databases[@]}; do
  15.  
  16.  
  17. if echo "${excludes[@]}" | grep -w "$db" >> /dev/null; then
  18.  
  19. echo "Se omite $db"
  20. continue
  21.  
  22. fi
  23.  
  24.  
  25.  
  26. mysqldump $db > ${dir}/${db}.sql || { echo se encontraron errores; break; }
  27.  
  28. done
  29.  
  30.  
  31. echo "Fin del programa"
Advertisement
Add Comment
Please, Sign In to add comment