|
  
|
1#
发表于 2009-3-8 00:40
| 只看该作者
vi /tmail/scripts/sysbak.php- #!/tmail/httpd/php/bin/php -q
- <?php
- //数据库连接信息
- $dbhost = "localhost";
- $dbuser = "tmail";
- $dbpass = "tmail";
- $dbname = "tmail";
- $link = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
- mysql_select_db($dbname);
- $week = date('w');
- $date = date('YmdHis');
- $sql = "SELECT mailbase FROM tmail_sysinfo";
- $result = mysql_query($sql,$link);
- $row = mysql_fetch_assoc($result);
- $mailbase = $row['mailbase'];
- //echo $bakcmd;
- $sql = "SELECT * FROM tmail_bak";
- $result = mysql_query($sql,$link);
- $row = mysql_fetch_assoc($result);
- //echo $row['bakdate'];
- if(file_exists($row['bakpath'])==false){
- @mkdir($row['bakpath']);
- }
- $bakcmd = "/bin/tar -jcf ".$row['bakpath']."/tmail".$date.".tar.bz2 /tmail/mysql/var/tmail ".$mailbase;
- $str = explode(',',$row['bakdate']);
- if($str[0]==$week){
- system($bakcmd);
- }elseif($str[1]==$week){
- system($bakcmd);
- }elseif($str[2]==$week){
- system($bakcmd);
- }elseif($str[3]==$week){
- system($bakcmd);
- }elseif($str[4]==$week){
- system($bakcmd);
- }elseif($str[5]==$week){
- system($bakcmd);
- }elseif($str[6]==$week){
- system($bakcmd);
- }
- ?>
复制代码- chmod +x /tmail/scripts/sysbak.php
复制代码 每天两天备份- echo "0 2 * * * /tmail/scripts/sysbak.php" >> /var/spool/cron/root
复制代码 |
|