How Linux implements scheduled backups of MySQL database (code)

This article brings you the content is about how to implement a regular backup of Linux MySQL Database (code), there is a certain reference value, the need for a friend can refer to, I hope to help you.

1. Check the disk space situation:

[root@localhost backup]# df-h file system                 capacity  used with  available% mount point/dev/mapper/centos-root   17G  2.7G   15G   16%/devtmpfs                 476M     0  476M    0%/devtmpfs                    488M     0  488M    0%/DEV/SHMTMPFS                    488M  7.7M  480M    2%/runtmpfs                    488M     0  488M    0%/sys/fs/cgroup/dev/sda1               1014M  130M  885M   13%/boottmpfs                     98M     0   98M    0%/run/user/0[root@localhost backup]#

Select the appropriate disk to hold the backup file

2. Create a backup directory:

Cd/homemkdir BACKUPCD Backup

3. Create a backup shell script:

Create a backup script under the directory you created (vi bkdatabasename.sh)

#!/bin/bashmysqldump-uroot-proot Rtak >/data/backup/rtak_$ (Date +%y%m%d_%h%m%s). Sqlmysqldump-uroot-proot Rtak | gzip >/data/backup/rtak_$ (Date +%y%m%d_%h%m%s). sql.gz

Note:

Bkdatabasename.sh replaced with interesting names

SQL backup and GZ Backup can be either optional or full backup

User name password needs to be replaced

4. Add executable permissions:

chmod u+x bkdatabasename.sh

Test whether the file is performing normally (./bkdatabasename.sh)

Note: (1) If error mysqldump: Command not Found, execute

Ln-fs/usr/local/mysql/bin/mysqldump/usr/bin (/usr/local/mysql path to MySQL installation path)

(2) If there is a warning (warning:using a password on the command line interface can be insecure.) may be ignored.

(3) Check whether the backup SQL file is normal and import the database correctly

5. Add a Scheduled task

Confirm that the crontab is installed:

Execute the crontab command if you do not found, it indicates that there is no installation

Execute command:

Crontab-e

Enter the following and save:

*/* * 1 * */data/backup/bkdatabasename.sh

/* * 1 * */several * represents the minute of the day of the month the days of the week perform a backup operation

Example: Perform backup per minute/1 * * * */(TESTED)

Perform backup daily 3 o'clock in the morning/00 3 * * */(not tested)

6. Stop the backup operation

When you do not need a scheduled backup, perform this operation, the normal process to the fifth step is completed ~

Crontab-r

Note: Timely cleanup of long-overdue SQL backups to prevent the disk from being fully occupied