Source tự động back up database

red_strike · 1/3/07

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 · 2/3/07

đâ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 · 2/3/07

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:

<?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 · 2/3/07

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 · 2/3/07

Đượ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 · 4/3/07

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 · 4/3/07

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

red_strike · 4/3/07

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

Source tự động back up database

red_strike

C O N T R A

hikaru_anh

Legend of Zelda

Tào_Tung

Mr & Ms Pac-Man

red_strike

C O N T R A

Tào_Tung

Mr & Ms Pac-Man

red_strike

C O N T R A

Tào_Tung

Mr & Ms Pac-Man

red_strike

C O N T R A