Realization Method of Timing Backup of MySQL Database

  • 2021-11-24 03:12:34
  • OfStack

1. Create an shell script

  Create the script as follows: 
 name="$(date +"%Y%m%d%H%M%S")" 
 /usr/bin/mysqldump -u$db_user -p$db_passwd $db_name >>/home/backup/$name.sql
 /usr/bin/mysqldump  : mysql Under the database installation directory mysqldump Backup tool path 
 dbname  Name of database to be backed up 
 /home/backup/$name.sql  Backup file output location can be set according to the situation 

2. Add execute permissions to the shell script

chmod +x

3. Add timed tasks to scripts

crontab -e
 Input on 1 Row naming for editing timing task , Finally, add the following 
00 01 * * * /bin/sh /usr/local/mysql/
 The above timed task means every morning 1 Point will perform automatic backup feet , Go on MySQL Timed backup of database .

Description of the crontab file:

In the crontab file created by users, each line represents a timing task, and each field in each line represents a setting. Its format is divided into 6 fields in each line, the first 5 sections are time setting fields, and the sixth section is the command field to be executed.

The format is as follows: minute hour day month week command

Parameter description:

minute: Represents minutes and can be any integer from 0 to 59.
hour: Represents an hour and can be any integer from 0 to 23.
day: Represents a date and can be any integer from 1 to 31.
month: Represents the month and can be any integer from 1 to 12.
week: Represents the day of the week and can be any integer from 0 to 7, where 0 or 7 represents Sunday.
command: To execute the command, can be Linux system commands, can also be written by their own script files.


Related articles: