Shulou(Shulou.com)05/31 Report--

This article mainly introduces how the CentOS/RHEL system automatically backs up the MySQL database every day. It is very detailed and has a certain reference value. Interested friends must finish reading it!

1. First, create the following three folders under the server: / bak, / bak/bakmysql, / bak/bakmysqlold.

[root@server21] # mkdir-p / bak/bakmysql {, old}

Create a shell script under the / bak/bakmysql folder:

[root@server21 ~] # touch / bak/bakmysql/backup.sh

To authorize a file:

[root@server21 ~] # chmod 755 / bak/bakmysql/backup.sh

two。 Edit the shell script:

[root@server21 ~] # vim / bak/bakmysql/backup.sh

#! / bin/bash

Cd / bak/bakmysql

Echo "You are in bakmysql directory"

Mv bakmysql* / bak/bakmysqlold

Echo "Old databases are moved to bakmysqlold folder"

Now=$ (date + "% Y-%m-%d")

File=bakmysql-$Now.sql

Mysqldump-uroot-paired password 'db_bbs > $File

Echo "Your database backup successfully completed"

SevenDays=$ (date-d-7day + "% Y-%m-%d")

If [- f / bak/bakmysqlold/bakmysql-$SevenDays.sql]; then

Rm-rf / bak/bakmysqlold/bakmysql-$SevenDays.sql

Echo "You have delete 7days ago backup file"

Else

Echo "7 days ago backup file not exist"

Fi

Change the red font in the 3.Shell script mysqldump-uroot-paired password 'db_bbs > $File statement to your own mysql database user, password, and database name, respectively. The script first moves the backup files whose bakmysql starts with the file name in the / bak/bakmysql folder to / bak/bakmysqlold, then generates the latest backup files, and finally determines whether the files from seven days ago exist in the / bak/bakmysqlold folder, deletes them, and ends at last. This automatically backs up the database scripts for the last seven days.

4. Set the shell script to be executed automatically every day:

[root@server21 ~] # vim / etc/crontab add this line at the end (please refer to the notes in / etc/crontab for details)

0 0 * root / bak/bakmysql/backup.sh

Restart crontab:

[root@server21 ~] # / sbin/service crond restart

If crontab is not set to boot, you can set it to boot as follows:

[root@server21 ~] # chkconfig-level 35 crond on

The above is all the contents of the article "how to automatically back up MySQL database in CentOS/RHEL system every day". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.