Advertisement
asanchez75

linux/backup/alldatabases

Jun 10th, 2011
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. #!/bin/bash
  2. array=(
  3. taller
  4. taller2
  5. taller3
  6. )
  7. len=${#array[*]}
  8. USER="root"
  9. PASS="contrasena"
  10. DIR="/BCK_MYSQL"
  11. DATE=`date +%d%m%Y.%H%M`
  12. cd $DIR
  13. i=0
  14. while [ $i -lt $len ]; do
  15. `mysqldump --opt --user=$USER --password=$PASS ${array[$i]} > ${array[$i]}.$DATE.sql`
  16. `tar zcvf ${array[$i]}.$DATE.tar.gz ${array[$i]}.$DATE.sql`
  17. s`rm ${array[$i]}.$DATE.sql`
  18. echo "BASE ${array[$i]} --- OK"
  19. let i++
  20. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement