Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function dobackupdb()
- {
- global $SITENAME, $CURUSER, $DEFAULTBASEURL, $backupdb_interval, $queries, $query_stat;
- set_time_limit(1200);
- $result = mysql_query("show processlist") or sqlerr(__FILE__, __LINE__);
- while ($row = mysql_fetch_array($result)) {
- if (($row["Time"] > 100) || ($row["Command"] == "Sleep")) {
- $sql = "kill " . $row["Id"] . "";
- mysql_query($sql) or sqlerr(__FILE__, __LINE__);
- }
- }
- ignore_user_abort(1);
- /* Your db-globals */
- global $mysql_host, $mysql_user, $mysql_pass, $mysql_db, $DEFAULTBASEURL, $backup_dir, $backupdb_interval;
- $host = 'localhost';
- $db = 'installer';
- $user = 'root';
- $pass = 'xx';
- /* Change to the name of your backup directory */
- $backupdir = '/backup';
- /* Compute day, month, year, hour and min. */
- $today = getdate();
- $day = $today['mday'];
- if ($day < 10) {
- $day = "0$day";
- }
- $month = $today['mon'];
- if ($month < 10) {
- $month = "0$month";
- }
- $year = $today['year'];
- $hour = $today['hours'];
- $min = $today['minutes'];
- $sec = "00";
- /* Add path to your backup dir here, eg; /var/www/ or C://AppServ/www/ */
- $dir = "C://AppServ/www/";
- /*
- Execute mysqldump command.
- It will produce a file named $db-$year$month$day-$hour$min.gz
- under $DOCUMENT_ROOT/$backupdir
- getenv('DOCUMENT_ROOT'),
- */
- // ///////windows mysqldump
- 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));
- $name = $db . "-" . $day . "-" . $month . "-" . $year . ".gz";
- $date = date("Y-m-d");
- $day = date("d");
- /*
- //////////Liux mysqldump
- 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 ));
- $name = $db."-".$day."-".$month."-".$year.".gz";$date = date("Y-m-d");
- $day = date("d");
- */
- write_log("autobackupdb----------------------Auto Back Up Complete--------------------");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement