What alternative methods can be used to create a MySQL dump in PHP if "mysqldump" is not available?

If "mysqldump" is not available, an alternative method to create a MySQL dump in PHP is to use PHP functions to fetch the data from the database tables and write it to a file in SQL format. This can be achieved by querying the database tables, fetching the results, and then writing them to a file in the appropriate SQL format. 

<?php

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Fetch data from database tables
$tables = array("table1", "table2");

$sql = '';

foreach($tables as $table) {
    $result = $conn->query("SELECT * FROM $table");

    while($row = $result->fetch_assoc()) {
        $sql .= "INSERT INTO $table VALUES (";
        foreach($row as $value) {
            $sql .= "'" . $conn->real_escape_string($value) . "',";
        }
        $sql = rtrim($sql, ',');
        $sql .= ");\n";
    }
}

// Write data to file
$file = 'backup.sql';
file_put_contents($file, $sql);

echo "MySQL dump created successfully.";

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

?>

Keywords

PHP MySQL database backup exec shell_exec

Related Questions