How can PHP be used to send SQL backups via email in a secure and efficient manner?

To send SQL backups via email in a secure and efficient manner using PHP, you can create a script that connects to the database, exports the SQL backup, and then sends it as an attachment in an email. This can be achieved by using PHP's built-in functions for database connectivity, file handling, and email sending. 

<?php
// Set up database connection parameters
$servername = "localhost";
$username = "username";
$password = "password";
$database = "database";

// Create database connection
$conn = new mysqli($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Export SQL backup
$backup_file = 'backup.sql';
exec("mysqldump --user=$username --password=$password --host=$servername $database > $backup_file");

// Send email with backup attachment
$to = "recipient@example.com";
$subject = "SQL Backup";
$message = "Please find attached the SQL backup.";
$from = "sender@example.com";
$attachment = chunk_split(base64_encode(file_get_contents($backup_file)));
$filename = "backup.sql";

$headers = "From: $from\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"boundary\"\r\n";

$body = "--boundary\r\n";
$body .= "Content-Type: text/plain; charset=\"utf-8\"\r\n";
$body .= "Content-Transfer-Encoding: 7bit\r\n\r\n";
$body .= $message . "\r\n";
$body .= "--boundary\r\n";
$body .= "Content-Type: application/octet-stream; name=\"$filename\"\r\n";
$body .= "Content-Transfer-Encoding: base64\r\n";
$body .= "Content-Disposition: attachment\r\n\r\n";
$body .= $attachment . "\r\n";
$body .= "--boundary--";

mail($to, $subject, $body, $headers);

// Close database connection
$conn->close();

// Delete backup file
unlink($backup_file);
?>

Keywords

PHP SQL backups email secure efficient

Related Questions