SHOW:
|
|
- or go back to the newest paste.
| 1 | !/bin/bash | |
| 2 | ||
| 3 | USER="root" | |
| 4 | PASSWORD="password" | |
| 5 | OUTPUT="/home/mysql_backup/`date +%w`" | |
| 6 | ||
| 7 | - | rm "$OUTPUTDIR/*gz" > /dev/null 2>&1 |
| 7 | + | rm -rf $OUTPUTDIR/*gz > /dev/null 2>&1 |
| 8 | ||
| 9 | databases=`mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database` | |
| 10 | ||
| 11 | for db in $databases; do | |
| 12 | if [[ "$db" != "information_schema" ]] && [[ "$db" != _* ]] ; then | |
| 13 | echo "Dumping database: $db" | |
| 14 | mysqldump --force --opt --user=$USER --password=$PASSWORD --databases $db > $OUTPUT/`date +%Y%m%d`.$db.sql | |
| 15 | gzip $OUTPUT/`date +%Y%m%d`.$db.sql | |
| 16 | fi | |
| 17 | done |
