MySQL 实现点餐系统的数据备份定时任务功能

CREATE TABLE `backup_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `backup_time` datetime NOT NULL COMMENT '备份时间',
  `backup_file_path` varchar(255) NOT NULL COMMENT '备份文件路径',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

#!/bin/bash

# 备份路径
BACKUP_PATH="/path/to/backup"

# 数据库连接相关信息
DB_HOST="localhost"
DB_USER="root"
DB_PASS="passWord"
DB_NAME="your_database_name"

# 备份文件名
BACKUP_FILE="${BACKUP_PATH}/backup_$(date +%Y%m%d_%H%M%S).sql"

# 执行备份命令
mysqldump -h${DB_HOST} -u${DB_USER} -p${DB_PASS} ${DB_NAME} > ${BACKUP_FILE}

# 记录备份信息到数据库
mysql -h${DB_HOST} -u${DB_USER} -p${DB_PASS} -e"INSERT INTO backup_records (backup_time, backup_file_path) VALUES (NOW(), '${BACKUP_FILE}');"

crontab -e

0 3 * * * /bin/bash /path/to/backup.sh