Advertisement
Guest User

Untitled

a guest
Jun 3rd, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.17 KB | None | 0 0
  1. function dobackupdb()
  2. {
  3.     global $SITENAME, $CURUSER, $DEFAULTBASEURL, $backupdb_interval, $queries, $query_stat;
  4.     set_time_limit(1200);
  5.     $result = mysql_query("show processlist") or sqlerr(__FILE__, __LINE__);
  6.     while ($row = mysql_fetch_array($result)) {
  7.         if (($row["Time"] > 100) || ($row["Command"] == "Sleep")) {
  8.             $sql = "kill " . $row["Id"] . "";
  9.             mysql_query($sql) or sqlerr(__FILE__, __LINE__);
  10.         }
  11.     }
  12.     ignore_user_abort(1);
  13.     /* Your db-globals */
  14.     global $mysql_host, $mysql_user, $mysql_pass, $mysql_db, $DEFAULTBASEURL, $backup_dir, $backupdb_interval;
  15.     $host = 'localhost';
  16.     $db = 'installer';
  17.     $user = 'root';
  18.     $pass = 'xx';
  19.  
  20.     /* Change to the name of your backup directory */
  21.     $backupdir = '/backup';
  22.     /* Compute day, month, year, hour and min. */
  23.     $today = getdate();
  24.     $day = $today['mday'];
  25.     if ($day < 10) {
  26.         $day = "0$day";
  27.     }
  28.     $month = $today['mon'];
  29.     if ($month < 10) {
  30.         $month = "0$month";
  31.     }
  32.     $year = $today['year'];
  33.     $hour = $today['hours'];
  34.     $min = $today['minutes'];
  35.     $sec = "00";
  36.     /* Add path to your backup dir here, eg; /var/www/ or C://AppServ/www/ */
  37.     $dir = "C://AppServ/www/";
  38.     /*
  39. Execute mysqldump command.
  40. It will produce a file named $db-$year$month$day-$hour$min.gz
  41. under $DOCUMENT_ROOT/$backupdir
  42. getenv('DOCUMENT_ROOT'),
  43. */
  44.  
  45.     // ///////windows mysqldump
  46.     system(sprintf('c:\AppServ\mysql\bin\mysqldump --opt -h %s -u %s -p%s %s  > %s/%s/%s-%s-%s-%s.sql', $host, $user, $pass, $db, getenv('DOCUMENT_ROOT'), $backupdir, $db, $day, $month, $year));
  47.     $name = $db . "-" . $day . "-" . $month . "-" . $year . ".gz";
  48.     $date = date("Y-m-d");
  49.     $day = date("d");
  50.     /*
  51.     //////////Liux mysqldump
  52. system(sprintf( '/usr/bin/mysqldump --opt -h %s -u %s -p%s %s  > %s/%s/%s-%s-%s-%s.sql', $host,  $user,  $pass,  $db,  getenv('DOCUMENT_ROOT'),  $backupdir,  $db,  $day,  $month,  $year ));
  53.     $name = $db."-".$day."-".$month."-".$year.".gz";$date = date("Y-m-d");
  54.     $day = date("d");
  55.     */
  56.     write_log("autobackupdb----------------------Auto Back Up Complete--------------------");
  57. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement