The content of this article is about how to implement scheduled backup of mysql database (code) in Linux. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.
[root@localhost backup]# df -h 文件系统 容量 已用 可用 已用% 挂载点 /dev/mapper/centos-root 17G 2.7G 15G 16% / devtmpfs 476M 0 476M 0% /dev tmpfs 488M 0 488M 0% /dev/shm tmpfs 488M 7.7M 480M 2% /run tmpfs 488M 0 488M 0% /sys/fs/cgroup /dev/sda1 1014M 130M 885M 13% /boot tmpfs 98M 0 98M 0% /run/user/0 [root@localhost backup]#
Select the appropriate disk to store the backup file
cd /home mkdir backup cd backup
Create a backup script (vi bkDatabaseName.sh) in the created directory
#!/bin/bash mysqldump -uroot -proot rtak > /data/backup/rtak_$(date +%Y%m%d_%H%M%S).sql mysqldump -uroot -proot rtak | gzip > /data/backup/rtak_$(date +%Y%m%d_%H%M%S).sql.gz
Note:
Replace bkDatabaseName.sh with an interesting name
You can choose one of sql backup and gz backup, or full backup
The username and password need to be replaced
chmod u+x bkDatabaseName.sh
Test whether the file can be executed normally (./bkDatabaseName.sh)
Note: (1) If the error mysqldump: command not found, execute
ln -fs /usr/local/mysql/bin/mysqldump /usr/bin (/usr/local/mysql path is the mysql installation path)
(2) If there is a warning (Warning: Using a password on the command line interface can be insecure.) can be ignored.
(3) Check whether the backup sql file is normal and whether the database can be imported normally
Confirm whether crontab is installed:
Execute If the crontab command reports command not found, it means that it is not installed.
Execute the command:
crontab -e
Enter the following content and save:
*/* * 1 * * /data/backup/bkDatabaseName.sh
/* * 1 * * / Several * Represents the minutes, hours, dates, months, and days of the week to perform backup operations.
For example: perform backups every minute/1 * * * * / (tested)
Perform backups at 3 a.m. every day/00 3 * * * / (Not tested)
When regular backup is not required, perform this operation. The normal process will be completed in step five~
crontab -r
Note: Clean up the long-expired sql backup in time to prevent the disk from filling up
Related recommendations:
Linux scheduled backup mysql database_MySQL
How to implement automatic daily backup of mysql database under linux_MySQL
The above is the detailed content of How to implement scheduled backup of mysql database in Linux (code). For more information, please follow other related articles on the PHP Chinese website!