What is the recommended method for creating a backup of a MySQL database in PHP?

Creating a backup of a MySQL database in PHP involves using the `mysqldump` command-line tool to export the database structure and data to a file. This can be achieved by executing the `mysqldump` command using `shell_exec()` function in PHP. 

<?php

// Set database credentials
$host = 'localhost';
$user = 'username';
$password = 'password';
$database = 'database_name';

// Set backup file path
$backup_file = 'backup.sql';

// Execute mysqldump command to create backup
$command = "mysqldump --host=$host --user=$user --password=$password $database > $backup_file";
$output = shell_exec($command);

// Check if backup was successful
if ($output === null) {
    echo 'Backup created successfully.';
} else {
    echo 'Backup creation failed.';
}

?>

Keywords

MySQL database backup PHP mysqldump cron job

Related Questions