创建mysqlbackup失败

GRANT LOCK TABLES, SELECT, SHOW VIEW ON *.* TO 'backupuser'@'localhost';
FLUSH PRIVILEGES;

df -h /path/to/backup/directory

systemctl status mysql

systemctl start mysql

mysqldump -u username -p database_name > backup_file.sql

ping mysql_server_ip

#!/bin/bash

# 数据库连接信息
DB_USER="username"
DB_PASS="password"
DB_NAME="database_name"
BACKUP_DIR="/path/to/backup/directory"
BACKUP_FILE="backup_$(date +%Y%m%d%H%M%S).sql"

# 创建备份目录
mkdir -p $BACKUP_DIR

# 执行备份命令
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/$BACKUP_FILE

# 检查备份是否成功
if [ $? -eq 0 ]; then
    echo "Backup completed successfully: $BACKUP_DIR/$BACKUP_FILE"
else
    echo "Backup failed!"
fi