'.$outfile; return shell_exec($command_line); }; function compress($source, $archive) { if(!$fh = fopen($source, 'r')){ die('Open failed for '.$source); } if(!$data = file_get_contents($source)){ die('Read failed for '.$source); } if(!fclose($fh)){ die('Close failed for '.$source); } if(!$zp = gzopen($archive, 'w9')){ die('gzopen failed for '.$archive); } if(!gzwrite($zp, $data)){ die('gzwrite failed for '.$zp); } if(!gzclose($zp)){ die('gzclose failed for '.$zp); } return true; }; $dbs = array(); $parts = list_directory($sql_src_dir) or die('Cannot locate '.$sql_src_dir.''); natcasesort($parts); foreach($parts as $part){ $pieces = explode('/', $part); $dbs[] = $pieces[5]; // echo "\n".$pieces[5].'

'; } $num_dbs = count($dbs); if(empty($num_dbs)){ die('

Directory scan failed

'); } foreach($dbs as $db){ // $outfile will be appended below $outfile = $target_dir.$db.'/'.date('Y-m-d').'.sql'; if(!file_exists($outfile)){ echo "\n".'

File not found: '.$outfile.'

'; }elseif(!is_readable($outfile)){ echo "\n".'

Cannot read file: '.$outfile.'

'; }else{ $archive = $outfile.'.gz'; if(!compress($outfile, $archive)){ echo "\n".'

Cannot move '.$outfile.' to '.$archive.'

'; }else{ echo "\n".'

'.$outfile.'
   --> '.$archive.'

'; unlink($outfile); } } } ?>