Skript pro zálohu db spuštěný cronem nefunguje…

$db_host="localhost"; //mysql host $db_user="*******"; //databse user name $db_pass="*******"; //database password $db_name="******"; //database name $tables="*"; // use * for all tables or use , to seperate table names $email="*******"; //your email id /////////////////////////////////////////////////////////////////////////////////////////// /////////don't need to change bellow ////// backup($db_host,$db_user,$db_pass,$db_name,$tables,$email); function backup($db_host,$db_user,$db_pass,$db_name,$tables = '*',$email) { $con= mysql_connect($db_host,$db_user,$db_pass); mysql_select_db($db_name,$con); //get all of the tables if($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while($row = mysql_fetch_row($result)) { $tables[] = $row; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); } //cycle through foreach($tables as $table) { $result = mysql_query('SELECT * FROM '.$table); $num_fields = mysql_num_fields($result); $return.= 'DROP TABLE '.$table.';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); $return.= "nn".$row2.";nn"; for ($i = 0; $i < $num_fields; $i++) { while($row = mysql_fetch_row($result)) { $return.= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j<$num_fields; $j++) { $row = addslashes($row); $row = ereg_replace("n","\n",$row); if (isset($row)) { $return.= '"'.$row.'"' ; } else { $return.= '""'; } if ($j<($num_fields-1)) { $return.= ','; } } $return.= ");n"; } } $return.="nnn"; } //save file $filename='db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql'; $handle = fopen($filename,'w+'); fwrite($handle,$return); fclose($handle); compress($filename); send_mail($filename.".zip",$email); } function send_mail($filepath,$email) { $from = "Backup ";

$subject = "Database backup";

$message="This attachment contains the backup of your database.";

$separator = md5(time());

// carriage return type (we use a PHP end of line constant)

$eol = PHP_EOL;

// attachment name

$filename = "backup.zip";

//$pdfdoc is PDF generated by FPDF

$attachment = chunk_split(base64_encode(file_get_contents($filepath)));

// main header

$headers = "From: ".$from.$eol;

$headers .= "MIME-Version: 1.0".$eol;

$headers .= "Content-Type: multipart/mixed; boundary="".$separator.""";

// no more headers after this, we start the body! //

$body = "--".$separator.$eol;

$body .= "Content-Transfer-Encoding: 7bit".$eol.$eol;

$body .= "This is a MIME encoded message.".$eol;

// message

$body .= "--".$separator.$eol;

$body .= "Content-Type: text/html; charset="iso-8859-1"".$eol;

$body .= "Content-Transfer-Encoding: 8bit".$eol.$eol;

$body .= $message.$eol;

// attachment

$body .= "--".$separator.$eol;

$body .= "Content-Type: application/octet-stream; name="".$filename.""".$eol;

$body .= "Content-Transfer-Encoding: base64".$eol;

$body .= "Content-Disposition: attachment".$eol.$eol;

$body .= $attachment.$eol;

$body .= "--".$separator."--";

// send message

if (mail($email, $subject, $body, $headers)) {

echo "Your backup sent to your email id";

header("refresh: 1; main.php");

} else {

echo "Oops mail can not be send";

}

}

function compress($filepath)

{

$zip = new ZipArchive();

$file=$filepath.".zip";

if($zip->open($file,1?ZIPARCHIVE::OVERWRITE:ZIPARCHIVE::CREATE)===TRUE)

{

// Add the files to the .zip file

$zip->addFile($filepath);

// Closing the zip file

$zip->close();

}

}

Skript funguje bezvadně, spouštím-li ho ručně (načtením url skriptu) - na e-mail dorazí zazipovaná záloha. Avšak nechám-li skript spuštět cronem (na endoře.cz), nedorazí vůbec nic.

Nemá někdo tušení proč?

Děkuji za radu