Shulou(Shulou.com)06/01 Report--

Backup script

[root@iZ25kgnqio7Z mysqlback] # more mysqlbackup.sh

#! / bin/bash

Databases= ('oms3'' keyword')

Basepath='/alidata/mysqlback/'

User='mysql'

Passwd='xxxxx'

If [!-d "$basepath"]; then

Mkdir-p "$basepath"

Fi

For db in ${databases [*]}

Do

/ bin/nice-n 19 / usr/local/mysql/bin/mysqldump-u$user-p$passwd-- log-error=$basepath$db-$ (date +% Y%m%d). Log--database $db > $basepath$db-$ (date +% Y%m%d) .sql

/ bin/nice-n 19 tar zPcf $basepath$db-$ (date +% Y%m%d). Sql.tar.gz $basepath$db-$ (date +% Y%m%d) .sql

Find $basepath-mtime + 7-name "* .sql.tar.gz"-exec rm-rf {}\

Done

The result of the backup is:

-rw-r--r-- 1 msyql msyql 0 Apr 9 00:15 oms3-20170409.log

-rw-r--r-- 1 msyql msyql 3380316532 Apr 9 00:34 oms3-20170409.sql.tar.gz

-rw-r--r-- 1 msyql msyql 0 Apr 9 00:34 keyword-20170409.log

-rw-r--r-- 1 msyql msyql 251514712 Apr 9 00:39 keyword-20170409.sql.tar.gz

-rw-r--r-- 1 msyql msyql 0 Apr 10 00:15 oms3-20170410.log

-rw-r--r-- 1 msyql msyql 3387944108 Apr 10 00:35 oms3-20170410.sql.tar.gz

-rw-r--r-- 1 msyql msyql 0 Apr 10 00:35 keyword-20170410.log

-rw-r--r-- 1 msyql msyql 251643052 Apr 10 00:40 keyword-20170410.sql.tar.gz

-rw-r--r-- 1 msyql msyql 0 Apr 11 00:15 oms3-20170411.log

-rw-r--r-- 1 msyql msyql 3396607153 Apr 11 00:34 oms3-20170411.sql.tar.gz

-rw-r--r-- 1 msyql msyql 0 Apr 11 00:34 keyword-20170411.log

-rw-r--r-- 1 msyql msyql 251744735 Apr 11 00:39 keyword-20170411.sql.tar.gz

You can see that the size of the log log is 0recovery. the rule of MySQL is to write this file only if there is a problem, otherwise it will create an empty one, which is very different from ORACLE.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.