Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DBUSERNAME="***"
- DBPASS="****"
- BACKUPDIR="/path/<folder_name>/"
- TODAY=`date +"%A"`
- #enter database names here
- DBs=( database_name )
- #if backupdirectory doesn't exist, create it
- if [ ! -d "$BACKUPDIR" ]; then
- mkdir -p "$BACKUPDIR"
- fi
- for database in "${DBs[@]}"; do
- #concate directory path, today's day and dbname with .sql ext
- filename=$BACKUPDIR${database}_${TODAY}.sql
- #take dump
- mysqldump -u$DBUSERNAME -p$DBPASS $database > $filename
- #compress it
- gzip -f $filename
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement