Source tự động back up database

[red_strike]

Ko biết có cái nào như vậy ko?
Mình thử dùng phpMyBackUpPro mà sao chỉnh rùi mà chẳng thấy nó back up :(

 

[hikaru_anh]

đây, backup rùi gửi vào email http://www.itvietnam.net/forum/vbul...p-sql-va-email-hay-qua-1-host-kha-c-code.html

 

[Tào_Tung]

Thử cái này đi , change thông tin lại rùi up lên host , chỉ sử dụng cho host nào hỗ trợ cron jobs . Copy lại rùi save thành file backup.php , tạo 1 folder mới trên host là data rồi up vào đó .

<?php 
/* 
 * Backup script on server. 
 * 
 * Runs on the server, called by Cron. Connects to the mySQL 
 * database and creates a backup file of the whole database. 
 * Saves to file in current directory. 
 * 
 * @author Cow <[email protected]> 
 * @version 0.2 
 * @date 18/08/2004 
 * @package Backup Server 
 * Upgraded Ver 2.0 (sending sql backup as attachment 
 * as email attachment, or send to a remote ftp server by 
 * @co-authors Cool Surfer<[email protected]> and 
 * Neagu Mihai<[email protected]> 
 */ 

set_time_limit(0); 
$date = date("mdy-hia"); 
$dbserver = "localhost"; 
$dbuser = ""; 
$dbpass = ""; 
$dbname = ""; 
$file = "N-Cool-$date.sql.gz"; 
$gzip = TRUE; 
$silent = TRUE; 

function write($contents) { 
   if ($GLOBALS['gzip']) { 
      gzwrite($GLOBALS['fp'], $contents); 
   } else { 
      fwrite($GLOBALS['fp'], $contents); 
   } 
} 

mysql_connect ($dbserver, $dbuser, $dbpass); 
mysql_select_db($dbname); 

if ($gzip) { 
   $fp = gzopen($file, "w"); 
} else { 
   $fp = fopen($file, "w"); 
} 

$tables = mysql_query ("SHOW TABLES"); 
while ($i = mysql_fetch_array($tables)) { 
   $i = $i['Tables_in_'.$dbname]; 

   if (!$silent) { 
      echo "Backing up table ".$i."\n"; 
   } 

   // Create DB code 
   $create = mysql_fetch_array(mysql_query ("SHOW CREATE TABLE ".$i)); 

   write($create['Create Table'].";\n\n"); 

   // DB Table content itself 
   $sql = mysql_query ("SELECT * FROM ".$i); 
   if (mysql_num_rows($sql)) { 
      while ($row = mysql_fetch_row($sql)) { 
         foreach ($row as $j => $k) { 
            $row[$j] = "'".mysql_escape_string($k)."'"; 
         } 

         write("INSERT INTO $i VALUES(".implode(",", $row).");\n"); 
      } 
   } 
} 

$gzip ? gzclose($fp) : fclose ($fp); 

// Optional Options You May Optionally Configure 

$use_gzip = "yes";            // Set to No if you don't want the files sent in .gz format 
$remove_sql_file = "yes";  // Set this to yes if you want to remove the sql file after gzipping. Yes is recommended. 
$remove_gzip_file = "no"; // Set this to yes if you want to delete the gzip file also. I recommend leaving it to "no" 

// Configure the path that this script resides on your server. 

$savepath = ""; // Full path to this directory. Do not use trailing slash! 

$send_email = "yes";                        /* Do you want this database backup sent to your email? Yes/No? If Yes, Fill out the next 2 lines */ 
$to      = "[email protected] ";    // Who to send the emails to, enter ur correct id. 
$from    = "[email protected] ";  // Who should the emails be sent from?, may change it. 

$senddate = date("j F Y"); 

$subject = "MySQL Database Backup - $senddate"; // Subject in the email to be sent. 
$message = "Your MySQL database has been backed up and is attached to this email"; // Brief Message. 

$use_ftp = "no";                             // Do you want this database backup uploaded to an ftp server? Fill out the next 4 lines 
$ftp_server = "ftp.diendanpascal.com";               // FTP hostname 
$ftp_user_name = "mutsu"; // FTP username 
$ftp_user_pass = "leauwater";   // FTP password 
$ftp_path = "/"; // This is the path to upload on your ftp server! 

// Do not Modify below this line! It will void your warranty :-D! 

$date = date("mdy-hia"); 
$filename = "$savepath/$dbname-$date.sql"; 

if($use_gzip=="yes"){ 
 $filename2 = $file; 
} else { 
 $filename2 = "$savepath/$dbname-$date.sql"; 
} 


if($send_email == "yes" ){ 
 $fileatt_type = filetype($filename2); 
 $fileatt_name = "".$dbname."-".$date."_sql.tar.gz"; 
  
 $headers = "From: $from"; 
  
 // Read the file to be attached ('rb' = read binary) 
 echo "Openning archive for attaching:".$filename2; 
 $file = fopen($filename2,'rb'); 
 $data = fread($file,filesize($filename2)); 
 fclose($file); 

 // Generate a boundary string 
 $semi_rand = md5(time()); 
 $mime_boundary = "==Multipart_Boundary_x{$semi_rand}x"; 

 // Add the headers for a file attachment 
 $headers .= "\nMIME-Version: 1.0\n" ."Content-Type: multipart/mixed;\n" ." boundary=\"{$mime_boundary}\""; 

 // Add a multipart boundary above the plain message 
 $message = "This is a multi-part message in MIME format.\n\n"."--{$mime_boundary}\n" ."Content-Type: text/plain; charset=\"iso-8859-1\"\n" ."Content-Transfer-Encoding: 7bit\n\n" . 
 $message . "\n\n"; 

 // Base64 encode the file data 
 $data = chunk_split(base64_encode($data)); 

 // Add file attachment to the message 
 echo "|{$mime_boundary}|{$fileatt_type}|{$fileatt_name}|{$fileatt_name}|{$mime_boundary}|<BR>"; 
$message .= "--{$mime_boundary}\n" ."Content-Type: {$fileatt_type};\n" ." name=\"{$fileatt_name}\"\n"."Content-Disposition: attachment;\n" ." filename=\"{$fileatt_name}\"\n" ."Content-Transfer-Encoding: base64\n\n" . 
$data . "\n\n" ."--{$mime_boundary}--\n"; 
//$message.= "--{$mime_boundary}\n" ."Content-Type: {$fileatt_type};\n" ." name=\"{$fileatt_name}\"\n" "Content-Disposition: attachment;\n" ." filename=\"{$fileatt_name}\"\n" ."Content-Transfer-Encoding: base64\n\n" . 
// $data . "\n\n" ."--{$mime_boundary}--\n"; 


 // Send the message 
 $ok = @mail($to, $subject, $message, $headers); 
 if ($ok) { 
  echo "<h4><center><bg color=black><font color= blue>Database backup created and sent! File name $filename2 </p> 
Idea Conceived By [email protected]       
Programmer email: [email protected]</p> 
This is our first humble effort, pl report bugs, if U find any...</p> 
Email me at <>[email protected]  nJoY!! :) 
</color></center></h4>"; 

 } else { 
  echo "<h4><center>Mail could not be sent. Sorry!</center></h4>"; 
 } 
} 

if($use_ftp == "yes"){ 
 $ftpconnect = "ncftpput -u $ftp_user_name -p $ftp_user_pass -d debsender_ftplog.log -e dbsender_ftplog2.log -a -E -V $ftp_server $ftp_path $filename2"; 
 shell_exec($ftpconnect); 
 echo "<h4><center>$filename2 Was created and uploaded to your FTP server!</center></h4>"; 

} 

if($remove_gzip_file=="yes"){ 
 exec("rm -r -f $filename2"); 
} 
?>

Chỉnh sửa thông tin vê database .
Vào cron jobs ở host , chọn standard , rùi paste cái này vào command to run : php -f /home/useer name/www/data/backup.php ( đây là cái path up file này lên ở host )

 

[red_strike]

Cái đó có tự động backup theo thời gian định trước được ko ví dụ như cứ 1 ngày là nó tự động back up 1 lần?

 

[Tào_Tung]

Được chứ , ở cron jobs chọn thời gian cho nó back up .
Cái file php phía trên nhớ change lại cái mail , lười edit quá

 

[red_strike]

Wow, thanks ^_^!
Tớ cũng lười edit nên hỏi lun cho chắc

Còn đoạn command dùng cho cron job hữu ích nào nữa không?

---------------------------------------------------------------

Warning: gzopen(N-Cool-030307-1211pm.sql.gz) [function.gzopen]: failed to open stream: Permission denied in /home/rapvn/public_html/backdata/backup.php on line 41

Warning: gzwrite(): supplied argument is not a valid stream resource in /home/rapvn/public_html/backdata/backup.php on line 31

Warning: gzwrite(): supplied argument is not a valid stream resource in /home/rapvn/public_html/backdata/backup.php on line 31

- Nó báo lỗi như vậy thì tính sao đây? Cậu có thể hướng dẫn kỹ càng hơn không?

 

[Tào_Tung]

Bạn chmod nó lại thành 777 đã chứ

 

[red_strike]

Té ra tớ chỉ CMOD cái file chứ chưa CMOD thư mục hèn gì chạy hoài ko được
Cái này chạy tốt lắm qua cái này tớ cũng biết thêm công dụng của Cron Job