mysqlRestore.php

<?php

//streamer config
$global['createDatabase'] = 1;
$doNotIncludeConfig = 1;
require_once __DIR__ . '/../videos/configuration.php';

if (php_sapi_name() !== 'cli') {
    die('Command Line only');
}

ob_end_flush();


// Example usage
$globPattern = "{$global['systemRootPath']}videos/mysqldump-*.sql";
echo "Searching [{$globPattern}]" . PHP_EOL;
$glob = glob($globPattern);
foreach ($glob as $key => $file) {
    echo "($key) {$file} " . humanFileSize(filesize($file)) . PHP_EOL;
}

// Select the file to restore
if (isset($_SERVER['argv'][1]) && $_SERVER['argv'][1] == '-1') {
    $filename = end($glob);
} else {
    echo "Type the number of the file you want to restore, or press Enter to restore the latest file" . PHP_EOL;
    $option = trim(readline());

    if ($option === '') {
        $filename = end($glob);
    } else {
        $option = intval($option);
        $filename = $glob[$option];
    }
}

// Restore the selected file
if (restoreMySQLBackup($filename)) {
    echo "Database restored successfully from {$filename}" . PHP_EOL;
} else {
    echo "Failed to restore the database from {$filename}" . PHP_EOL;
}

?>