Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- STAMP=`date '+%Y_%m_%d'`
- DBUSER=root
- DBPASS=
- for i in `ls /home/`; do
- export LUSER=$i
- for x in `mysql -u$DBUSER -p$DBPASS -e 'show databases'|grep ^"$LUSER"_`; do
- # x je database name u ovom slucaju, dodaj/oduzmi stamp gdje ti pashe u nazivu
- mysqldump -u$DBUSER -p$DBPASS $x|gzip > /home/$LUSER/backup/$STAMP-$x.sql.gz
- done
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement