Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- databases=()
- backup_dir=/root/db_dump
- if [ ! -d $backup_dir ]; then
- mkdir -p $backup_dir
- fi
- cd $backup_dir
- for name in ${databases[@]}
- do
- for j in 7 6 5 4 3 2 1 0; do
- for i in $name.$j; do
- if [ -e $i.sql.bz2 ]; then
- mv $i.sql.bz2 ${i/.$j/}.$(( $j + 1 )).sql.bz2;
- fi
- done
- done
- mysqldump -u user -pPASS $name > ./$name.0.sql
- bzip2 -z $name.0.sql
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement