Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- suffix=`date +%d-%b-%Y`
- dest=/Backup/semanal/mysql
- cmd='/usr/bin/mysqldump'
- databases=(`echo 'show databases;' | mysql -u admin --password='xxxxxxx' | grep -v ^Database$`)
- for d in "${databases[@]}"; do
- if [[ $d != 'tmp' && $d != 'test' ]]
- then
- path="${dest}/${suffix}/${d}"
- mkdir -p ${path}
- ${cmd} --user=admin --password='4dm1n.dbyr' --quick --create-options ${d} | bzip2 -c > ${path}/${d}.sql.bz2
- fi
- done
- /bin/tar -cvzf /Backup/semanal/etc-${suffix}.tar.gz /etc >> /dev/null 2>&1
- /bin/tar -cvzf /Backup/semanal/www-${suffix}.tar.gz /var/www >> /dev/null 2>&1
- # delete old dumps (retain 5 days)
- find /Backup/semanal -mtime +5 -exec rm -rf {} \;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement