Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- DIR=/opt/sql
- USERNAME="userThatCanRead"
- PASSWORD="Password"
- rm $DIR/*.gz 2>&1 > /dev/null
- DATABASES=$(echo "SHOW DATABASES" | mysql -u $USERNAME --pass=$PASSWORD | grep -v Database)
- for DB in $DATABASES
- do
- if ( [ "${DB}" != "information_schema" ] && [ ${DB} != "performance_schema" ] )
- then
- mysqldump -u $USERNAME --password=$PASSWORD -c --databases ${DB} > $DIR/${DB}.sql
- gzip $DIR/${DB}.sql
- fi
- done
- DAY=`date +%u`
- if [ $DAY -eq '7' ]
- then
- DX=`date +%Y%m%d`
- for DB in $DATABASES
- do
- if ( [ "${DB}" != "information_schema" ] && [ ${DB} != "performance_schema" ] )
- then
- cp $DIR/${DB}.sql.gz $DIR/historical/${DB}-$DX.sql.gz
- fi
- done
- fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement