Advertisement
wmachuca

Export All MySQL Databases Linux

Sep 5th, 2017
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.72 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. ## Datos conexion a base de datos
  4. MYSQL_HOST="localhost"
  5. MYSQL_USER="root"
  6. MYSQL_PASS="MySQL"
  7.  
  8. ## Variables si los binarios no estan en el PATH
  9. MYSQL_BIN="/usr/bin/mysql"
  10. MYSQLDUMP_BIN="/usr/bin/mysqldump"
  11. FECHA=$(date '+%F')
  12.  
  13. OUTDIR="/mnt/e/backupbdl"
  14.  
  15. for DB in `$MYSQL_BIN -e "show databases" -h $MYSQL_HOST -u $MYSQL_USER -p"$MYSQL_PASS"`; do
  16.         if [ $DB != 'information_schema' ] && [ $DB != 'Database' ]  && [ $DB != 'mysql' ] && [ $DB != 'performance_schema' ]; then
  17.                 $MYSQLDUMP_BIN --routines --triggers --quote-names -h $MYSQL_HOST -u $MYSQL_USER -p"$MYSQL_PASS" $DB > $OUTDIR/$FECHA-$DB.sql
  18.                 echo -e "[*] Backup de $DB generado correctamente"
  19.         fi
  20. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement