How to import sql backup using php script ( Using PHP/PDO ).

Make a Copy of Tables using  PHP / PDO

session_start();
$con = include("config.php");
$filename = 'path_to_file/backup_db.sql';
// Temporary variable, used to store current query
$templine = '';
// Read in entire file
$lines    = file($filename);
// Loop through each line
foreach ($lines as $line) {
    // Skip it if it's a comment
    if (substr($line, 0, 2) == '--' || $line == '')
        continue;
 
    // Add this line to the current segment
    $templine .= $line;
    // If it has a semicolon at the end, it's the end of the query
    if (substr(trim($line), -1, 1) == ';') {
        $query    = $con->prepare($templine);         // Perform the query
        $done     = $query->execute();
        $templine = ''; //free up memory
    }
}
echo "Tables imported successfully";

---