dede数据库备份失败

GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON your_database.* TO 'your_user'@'localhost';
FLUSH PRIVILEGES;

$backup_path = '/path/to/backup/';
if (!file_exists($backup_path)) {
    mkdir($backup_path, 0777, true);
}

memory_limit = 256M

sudo systemctl status mysql
sudo systemctl start mysql

<?php
$db_host = 'localhost';
$db_user = 'your_user';
$db_pass = 'your_password';
$db_name = 'your_database';
$backup_path = '/path/to/backup/';

// 创建备份目录
if (!file_exists($backup_path)) {
    mkdir($backup_path, 0777, true);
}

// 备份文件名
$backup_file = $backup_path . $db_name . '_' . date('Y-m-d_H-i-s') . '.sql';

// 执行备份
$command = "mysqldump -h $db_host -u $db_user -p$db_pass $db_name > $backup_file";
exec($command, $output, $return_var);

if ($return_var === 0) {
    echo "Backup completed successfully: $backup_file";
} else {
    echo "Backup failed.";
}
?>