Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- MYSQL_USER=backup
- MYSQL_PASS=пароль
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- #
- # Collect all database names except for
- # mysql, information_schema, and performance_schema
- #
- SQL="SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN"
- SQL="${SQL} ('mysql','information_schema','performance_schema','nas') and schema_name not like '%#%'"
- DBLISTFILE=/tmp/DatabasesToDump.txt
- mysql ${MYSQL_CONN} -ANe"${SQL}" > ${DBLISTFILE} 2>/dev/null
- DBLIST=""
- for DB in `cat ${DBLISTFILE}` ; do DBLIST="${DBLIST} ${DB}" ; done
- MYSQLDUMP_OPTIONS="--routines --triggers --single-transaction"
- cd /opt/mysql
- mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} --databases ${DBLIST} > /opt/mysql/backup_`date +%Y%m%d`.sql
- find . -mtime +30 -type f -name 'backup_*.sql' -exec rm "{}" ";"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement