Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- ## Datos conexion a base de datos
- MYSQL_HOST="localhost"
- MYSQL_USER="root"
- MYSQL_PASS="MySQL"
- ## Variables si los binarios no estan en el PATH
- MYSQL_BIN="/usr/bin/mysql"
- MYSQLDUMP_BIN="/usr/bin/mysqldump"
- FECHA=$(date '+%F')
- OUTDIR="/mnt/e/backupbdl"
- for DB in `$MYSQL_BIN -e "show databases" -h $MYSQL_HOST -u $MYSQL_USER -p"$MYSQL_PASS"`; do
- if [ $DB != 'information_schema' ] && [ $DB != 'Database' ] && [ $DB != 'mysql' ] && [ $DB != 'performance_schema' ]; then
- $MYSQLDUMP_BIN --routines --triggers --quote-names -h $MYSQL_HOST -u $MYSQL_USER -p"$MYSQL_PASS" $DB > $OUTDIR/$FECHA-$DB.sql
- echo -e "[*] Backup de $DB generado correctamente"
- fi
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement