Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- dir="/home/educacionit/bases_datos"
- # crear un array con todas las bases de datos
- databases=( $(mysql -N -s -e "SHOW DATABASES;") )
- excludes=( "information_schema" "performance_schema" "sys" )
- for db in ${databases[@]}; do
- if echo "${excludes[@]}" | grep -w "$db" >> /dev/null; then
- echo "Se omite $db"
- continue
- fi
- mysqldump $db > ${dir}/${db}.sql || { echo se encontraron errores; break; }
- done
- echo "Fin del programa"
Advertisement
Add Comment
Please, Sign In to add comment