setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "
Connected successfully
\n";
echo "Liste de toutes les tables de la base
";
$sql = "SHOW TABLES";
echo "";
foreach ($conn->query($sql) as $row) {
echo "- Table: {$row[0]}
\n";
}
echo "
";
echo "Liste des tables
";
echo "Backing up {$dbname}
";
$sql = "SHOW TABLES like 'is%'";
// $sql = "SHOW TABLES like 'is%'"; // ajout d'un filtre dans les noms de table
echo "";
foreach ($conn->query($sql) as $row) {
$file = dirname(__FILE__) . '/backup-'.$date.'-'.$row[0].'.sql';
echo "- Dumping Table: {$row[0]} → {$file}
\n";
exec("mysqldump --user={$user} --password={$pass} --host={$host} {$dbname} --tables {$row[0]} --result-file={$file} 2>&1", $output);
var_dump($output);
}
echo "
";
}
catch(PDOException $e)
{
echo "Connection failed
\n";
echo $e->getMessage();
}
?>