How can PHP be used to create a MYSQL-Dump?

To create a MYSQL-Dump using PHP, you can use the `mysqldump` command-line utility in combination with PHP's `exec()` function. This allows you to generate a MYSQL-Dump file programmatically within your PHP script. 

<?php
$host = 'localhost';
$user = 'username';
$password = 'password';
$database = 'database_name';
$outputFile = 'dump.sql';

$command = "mysqldump --host=$host --user=$user --password=$password $database > $outputFile";
exec($command);

echo "MYSQL-Dump created successfully!";
?>

Keywords

PHP MYSQL-Dump database backup command line

Related Questions