SAE数据库完美备份（自动备份+发送邮件+数量可控）

<?php
/********************************************************************
** database backup for sae, code from xhhjin (http://xuhehuan.com) **
********************************************************************/
define('DB_DOMAIN','dbbackup');      //备份域
define('DB_BACKUP_PATH','backup');    //备份路径和文件名
define('DB_BACKUP_NUMBER', 20);      //备份数目限制，不超过900
define('DB_MAIL_SMTP', 'smtp.163.com');    //smtp服务器
define('DB_MAIL_PORT', 25);        //smtp端口
define('DB_MAIL_SENDEMAIL', '*******@163.com');  //发送邮件帐号
define('DB_MAIL_PASSWORD', '*******');    //发送邮件密码
define('DB_MAIL_TOEMAIL', '*******@qq.com');  //收信邮件帐号
header('Content-Type: text/html; charset=UTF-8');
$stor = new SaeStorage();
$attr = array('private'=>false);
$ret = $stor->setDomainAttr(DB_DOMAIN, $attr);
$date = date('Y-m-d');
$pathname = DB_BACKUP_PATH.'/'.$date.'.sql.zip';  //按日期命名
//备份数据库+发邮件
$dj = new SaeDeferredJob();
$taskID =$dj->addTask("export","mysql",DB_DOMAIN,$pathname,SAE_MYSQL_DB,"","");
$dbbackup_url = $stor->getUrl(DB_DOMAIN,$pathname);
$mail = new SaeMail();
if($taskID===false){echo("数据库备份失败, errno:".$dj->errno().", errmsg: " .$dj->errmsg()."。 <br>");$ret = $mail->quickSend( DB_MAIL_TOEMAIL , '数据库备份失败' , '数据库备份失败! errno:'.$dj->errno().', errmsg:'.$dj->errmsg().'.', DB_MAIL_SENDEMAIL , DB_MAIL_PASSWORD, DB_MAIL_SMTP, DB_MAIL_PORT ); //邮箱通知
}else{do {$ret = $dj->getStatus($taskID);} while ( $ret==='waiting' || $ret==='inqueue' || $ret==='excuting' );echo("数据库备份成功, taskID($taskID, $ret)。 <br>");$attachdata = file_get_contents($dbbackup_url);$mail->setAttach( array("db-$date.sql.zip.txt" => $attachdata));    //发送数据库附件，支持的文件后缀参考SAE文档，大小不超过1M$ret = $mail->quickSend( DB_MAIL_TOEMAIL , '数据库备份成功' , '数据库备份成功!'.' 备份地址：'.$dbbackup_url, DB_MAIL_SENDEMAIL , DB_MAIL_PASSWORD, DB_MAIL_SMTP, DB_MAIL_PORT ); //邮箱通知
}
//清理多余的备份文件
$domain = DB_DOMAIN;
$path = DB_BACKUP_PATH;
$limitNum = DB_BACKUP_NUMBER;
do {      //循环获取指定路径文件$fileArray = $stor->getListByPath($domain, $path, $limitNum+100, 0 );$fileList = $fileArray['files'];      // 文件名字列表数组$totalFileNum = $fileArray['fileNum'];    // 文件数目if($totalFileNum<=$limitNum) {    break;                      //路径下文件数目不大于限制数目，跳出循环}foreach($fileList as $key => $value){$fileTime[$key] = $value['uploadTime'];}array_multisort($fileTime, SORT_DESC, $fileList); // 按照文件上传时间降序排列//print_r($fileList);echo "<br>该目录总共有($totalFileNum)个文件！ <br>";for($i=0;$i<$limitNum;++$i){$file = $fileList[$i]['fullName'];}//清理限制数目之外的文件for($i=$limitNum;$i<$totalFileNum;$i++){$file = $fileList[$i]['fullName'];$stor->delete($domain,$file);$fileNum = count($fileList);}
} while ( $totalFileNum>$limitNum );
//显示清理路径结果
echo "Domain($domain)的路径($path)中只保留了最新上传的($limitNum)个文件，其余文件已被清除!";
$attr = array('private'=>true);
$ret = $stor->setDomainAttr(DB_DOMAIN, $attr); //设置domain为private，保护数据
?>

cron:
- description: database backupurl: /实际目录/dbbackup.phpschedule: every day of month 03:00
handle:
- hostaccess: if( path ~ "/实际目录/dbbackup.php" ) allow "127.0.0.1"