Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- BACKUP_DIR="/var/lib/mysql/backup"
- if [ -n "`pidof mysqld`" ] && [ -f "/var/lib/mysql/.my.cnf" ]; then
- mkdir -p $BACKUP_DIR
- chown mysql $BACKUP_DIR
- # backup datqabases
- # please create /var/lib/mysql/.my.cnf
- # [mysqldump] [mysql]
- # user=mysql
- # password=secret
- runuser -c 'mysql -Bse "SHOW DATABASES"|xargs -i sh -c "mysqldump --opt {} > /backup/data/mysql/{}.mysql"' mysql
- fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement