<?
//保存目录,路径要用反斜杠.您需要手动建立它.
$store_folder = 'E:\databse_backup';
//用户名和密码
//该帐号须有操作[所有]的数据库及FILE的权限
//否则有些数据库不能备份.
$db_username = "root";
$db_password = "suntun";
$time=time();
echo "**********************************************\n";
echo "* 今天是".date("Y年m月d日",$time)." *\n";
echo "* 欢迎使用xiaoc自动数据备份系统 *\n";
echo "* *\n";
echo "* www.music126.com *\n";
echo "* *\n";
echo "* 作者:王定伟 Email:cdwdw@163.com *\n";
echo "* *\n";
echo "* *\n";
echo "* *\n";
echo "**********************************************\n";
echo "\n备份即将开始.......\n";
echo "\n若要终止请按 Ctrl+C.......\n";
$nowdir = "$store_folder\\".date("Y年m月d日",$time)."";
if(file_exists("$nowdir.rar")) die("\n你已经备份过数据库了,如果要重复备份请先将原来的备份文件删除后再备份.\n");
@mkdir($nowdir);
mysql_connect("localhost","$db_username","$db_password");
$query=mysql_list_dbs();
while($result=mysql_fetch_array($query)){
system (dirname(__FILE__).'\..\mysql\bin\mysqldump --opt '."$result[Database] -u{$db_username} ".($db_password?"-p{$db_password}":"")." > $nowdir\\$result[Database].sql");
echo "\n正在备份数据库`$result[Database]`,请等待...\n";
}
echo "\n为保证文件的大小即将开始对备份进行压缩,请稍后...\n";
system( dirname(__FILE__)."\\WinRAR\\WinRAR.exe a -ep1 -r -o+ -m5 -df \"$nowdir.rar\" \"$nowdir\" " );
//删除 15 天前的文件
@unlink("$store_folder\\".date("Y年m月d日",$time-86400*15).".rar");
echo "\n数据库备份完毕!\n";
?>