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

SHELL automatically backs up MYSQL database

Back up a single database and all databases

The prodigal son of Yicheng is original, please indicate the source when reproduced!

For more technical blog posts, please see personal blog: https://fengchenglangzi.000webhostapp.com

Wechat bh29890922

QQ445718526 、 490425557

Partial screenshot:

one

two

three

four

five

six

seven

eight

nine

ten

eleven

twelve

thirteen

fourteen

fifteen

sixteen

seventeen

eighteen

nineteen

twenty

twenty-one

twenty-two

twenty-three

twenty-four

twenty-five

twenty-six

twenty-seven

twenty-eight

twenty-nine

thirty

thirty-one

thirty-two

thirty-three

thirty-four

thirty-five

thirty-six

thirty-seven

thirty-eight

thirty-nine

forty

forty-one

forty-two

forty-three

forty-four

forty-five

forty-six

forty-seven

forty-eight

forty-nine

fifty

fifty-one

fifty-two

fifty-three

fifty-four

fifty-five

fifty-six

fifty-seven

fifty-eight

fifty-nine

sixty

sixty-one

sixty-two

sixty-three

sixty-four

sixty-five

sixty-six

sixty-seven

sixty-eight

sixty-nine

seventy

seventy-one

seventy-two

seventy-three

seventy-four

seventy-five

seventy-six

seventy-seven

seventy-eight

seventy-nine

eighty

eighty-one

eighty-two

eighty-three

eighty-four

eighty-five

eighty-six

eighty-seven

eighty-eight

eighty-nine

ninety

ninety-one

ninety-two

ninety-three

ninety-four

ninety-five

ninety-six

ninety-seven

ninety-eight

ninety-nine

one hundred

one hundred and one

one hundred and two

one hundred and three

one hundred and four

one hundred and five

one hundred and six

one hundred and seven

one hundred and eight

one hundred and nine

one hundred and ten

one hundred and eleven

one hundred and twelve

one hundred and thirteen

one hundred and fourteen

one hundred and fifteen

one hundred and sixteen

one hundred and seventeen

one hundred and eighteen

one hundred and nineteen

one hundred and twenty

one hundred and twenty one

one hundred and twenty two

one hundred and twenty three

#! / bin/bash

# 2017-8-16 08:58:22

# By baiyuanhong

# Auto_Backup_Mysql

# # #

MYSQL_STATUS= `netstat-anpl | grep mysqld | grep 3306 | wc-l`

# # #

# # #

# system base info

IPADD= `ifconfig eth0 | grep "inet addr" | awk'{print $2}'| sed's AcaddrGREGUP G` `

HOSTNAME= `hostname`

DATE= `date + "% y-%m-%d% H:%M:%S" `

USER= `whoami`

DISK_SDA1= `df-h | grep / dev/sda1 | awk'{print $5}'`

CPU_INFO= `cat / proc/ loadavg`

# # #

# # #

# status_check

Echo-e "\ 033 [32m / 32m]

If [$MYSQL_STATUS-eq 0]; then

Echo "Mysql.. [NOT RUN]"

Else

Echo "Mysql.. [RUNNING]"

Fi

Echo-e "\ 033 [32m / 32m]

Cat / tmp/all_databases_ `date +% Y% m% d`.sql

Else

Exit

Fi

Fi

If [$input-eq 3]; then

Exit

Fi

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.