Código PHP:
<?php
$zip = new ZipArchive();
$backup = $_POST['backup'];
$data = $_POST['datas'];
date_default_timezone_set('America/Caracas');
$hoy = date("YmdHi", time());
$outfile = $backup."_".$hoy.".zip";
$directorio = "respaldos/";
$filename = $backup."_".$hoy.".sql";
if (!$backup)
{
echo "<script>alert('Ingrese nombre del respaldo!')</script>";
echo "<script> window.history.back(-1) </script>";
}
else
{
system("mysqldump -h localhost -u root $data > $directorio$filename");
if($zip->open($outfile,ZIPARCHIVE::CREATE)===true) {
$zip->addFile('$directorio$filename');
$zip->close();
echo "<script>alert('Creado '".$outfile.")</script>";
}
else {
echo 'Error creando '.$outfile;
}
echo "<script>alert('respaldo completado')</script>";
echo "<script> window.history.back(-1) </script>";
}
?>