Database MySQL Sub-Library backup script

Database MySQL sub-Library backup script

In the enterprise work, we often encounter database backup problems, of course, I did not mention the MySQL master, and now we

Let's look at the following script to see how the library can be backed up periodically:

VI mysql_backup.sh

#!/bin/sh

#backup Tiandao BBS edoing

#coding Tonye.li

Myuser=root

Mypass=meidi

Socket=/data/3306/mysql.sock

mycmd= "Mysql-u$myuser-p$mypass-s $SOCKET"

mydump= "Mysqldump-u$myuser-p$mypass-s $SOCKET"

For database in Tiandao BBS edoing

Do

$MYDUMP $database |gzip >/server/backup/${database}_$ (date + $F). sql.gz

Done

The above script tests the following, added to the scheduled task in the regular daily sub-Library for backup

This article is from "Lao Li _tony" blog, please be sure to keep this source http://tonyping.blog.51cto.com/7725720/1682988

Database MySQL Sub-Library backup script