Mysql automatic batch backup script _ MySQL

Mysql automatic batch backup script bitsCN.com

Get database name
# Cat datanames. sh
Passwd = xxxxxx
Mysql -- password = $ passwd <EOF
Show databases;
EOF
Backup Script
# Cat mysql_backup.sh
The retrieved system data library is stored in mysql.txt
./Datanames. sh | grep-v "Database" | grep-v "ianformation_schema"> mysql.txt
# Generate a database folder by date. The database contains the backup failure log.
I = 'cat mysql.txt'
Nd = 'date + % Y % m % d % H'
Dt = 'date + % Y % m % d % H % M % s'
Mkdir $ nd
For I in $ I
Do
/Usr/bin/mysqldump-pxxxxxx -- opt $ I> $ nd/$ nm-$ dt. SQL 2> $ dt/error.txt
Done
Add the mysqldump. sh script to the corntab and set it to be executed every day or every week! Mysql can be automatically backed up.
1 12 ****./root/mysql_backup.sh
Author "xavier"

BitsCN.com