function backup_mysql($ID){ $sock=new sockets(); $unix=new unix(); $date_start=time(); $mysqlhotcopy=$unix->find_program("mysqlhotcopy"); $email_spacer="=========================================="; if($mysqlhotcopy==null){ backup_events($ID,"mysql","ERROR, unable to stat mysqlhotcopy"); events("ERROR, unable to stat mysqlhotcopy",__FUNCTION__,__LINE__); send_email_events("Backup Task $ID:: Unable to backup mysql datas ","ERROR, unable to stat mysqlhotcopy","backup"); return false; } $array=backup_mysql_databases_list($ID); if(!is_array($array)){ events("ERROR, unable to get databases list",__FUNCTION__,__LINE__); send_email_events("Backup Task $ID:: Unable to backup mysql datas ","ERROR, unable to get databases list","backup"); backup_events($ID,"mysql","ERROR, unable to get databases list"); return false; } $q=new mysql(); if($q->mysql_password<>null){$password="******";} if($q->mysql_admin<>null){$user="******";} $temporarySourceDir=$sock->GET_INFO("ExecBackupTemporaryPath"); if($temporarySourceDir==null){$temporarySourceDir="/home/mysqlhotcopy";} $temporarySourceDir="$temporarySourceDir/mysql"; events("temporarySourceDir has ExecBackupTemporaryPath token was \"$temporarySourceDir\"",__FUNCTION__,__LINE__); events("Creating $temporarySourceDir",__FUNCTION__,__LINE__); @mkdir($temporarySourceDir,0666,true); if(!is_dir($temporarySourceDir)){ events("Creating Unable to backup mysql datas ","ERROR, $temporarySourceDir permission denied or no such file or directory",__FUNCTION__,__LINE__); send_email_events("Backup Task $ID:: Unable to backup mysql datas ","ERROR, $temporarySourceDir permission denied or no such file or directory","backup"); backup_events($ID,"mysql","ERROR, $temporarySourceDir permission denied or no such file or directory"); return ; } backup_events($ID,"mysql","INFO, using $temporarySourceDir for temp backup"); while (list ($num, $line) = each ($array)){ if(trim($line)==null){continue;} $database_name=trim(basename($line)); if(strtolower($database_name)=="log"){ events("skipping database \"$database_name\"",__FUNCTION__,__LINE__); backup_events($ID,"mysql","INFO, mysqlhotcopy skip log database"); continue; } if(strtolower($database_name)=="mysql"){ events("skipping database \"$database_name\"",__FUNCTION__,__LINE__); backup_events($ID,"mysql","INFO, mysqlhotcopy skip mysql database"); continue; } backup_events($ID,"mysql","INFO, mysqlhotcopy database ($database_name) stored in $line -> $temporarySourceDir"); $mysqlhotcopy_command="$mysqlhotcopy --addtodest$user$password $database_name $temporarySourceDir 2>&1"; events("\"$mysqlhotcopy_command\"",__FUNCTION__,__LINE__); exec($mysqlhotcopy_command,$results); while (list ($num_line, $evenement) = each ($results)){ if(preg_match("#No space left on device#",$evenement)){ events("ERROR, backup No space left on device ($temporarySourceDir)",__FUNCTION__,__LINE__); backup_events($ID,"mysql","ERROR, backup No space left on device ($temporarySourceDir)\n". implode("\n",$results)); if(is_dir($temporarySourceDir)){shell_exec("/bin/rm -rf $temporarySourceDir/*");} return; } events("$evenement",__FUNCTION__,__LINE__); if(preg_match("#failed:#",$evenement)){ events("ERROR, database: \"$database_name\" ($evenement)",__FUNCTION__,__LINE__); backup_events($ID,"mysql","ERROR, database: \"$database_name\" ($evenement)"); $fulltext=@implode("\n",$results); send_email_events("Backup Task $ID:: database: \"$database_name\" failed to backup ","$email_spacer\n$mysqlhotcopy_command$email_spacer\nERROR:$email_spacer\n$evenement\n$email_spacer\n$fulltext","backup"); } } backup_events($ID,"mysql","INFO, backup $database_name\n". implode("\n",$results)); if(strtolower($database_name)=="zarafa"){ events("zarafa database -> backup_mysql_database_mysqldump($ID,zarafa,$temporarySourceDir)",__FUNCTION__,__LINE__); backup_mysql_database_mysqldump($ID,"zarafa",$temporarySourceDir); } } backup_events($ID,"mysql","INFO, Send mysql backup to the \n". implode("\n",$results)); events("Creating directory \"{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql\"",__FUNCTION__,__LINE__); backup_mkdir("{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql"); backup_copy("$temporarySourceDir/*","mysql",$ID); backup_events($ID,"mysql","INFO, backup remove content of $temporarySourceDir/*"); events("INFO, backup remove content of $temporarySourceDir/*",__FUNCTION__,__LINE__); if(is_dir($temporarySourceDir)){ events("/bin/rm -rf $temporarySourceDir/*",__FUNCTION__,__LINE__); shell_exec("/bin/rm -rf $temporarySourceDir/*"); } backup_events($ID,"mysql","INFO, backup END without known error"); $date_end=time(); $calculate=distanceOfTimeInWords($date_start,$date_end); events("INFO, time: $calculate",__FUNCTION__,__LINE__); backup_events($ID,"mysql","INFO, time: $calculate"); }
function backup_freewebs($ID, $servername) { include_once dirname(__FILE__) . "/ressources/class.freeweb.inc"; $free = new freeweb($servername); backup_events($ID, $servername, "INFO, {$servername} Directory:`{$free->WORKING_DIRECTORY}`", __LINE__); $date_start = time(); if (!is_dir("{$free->WORKING_DIRECTORY}")) { backup_events($ID, $servername, "ERROR, {$servername} Directory:`{$free->WORKING_DIRECTORY}` no such directory", __LINE__); return; } $DestinationPath = "{$GLOBALS["MOUNTED_PATH_FINAL"]}/freewebs/{$servername}/www"; backup_mkdir($DestinationPath); if (!backup_isdir($DestinationPath)) { backup_events($ID, $servername, "ERROR, {$DestinationPath} permission denied or no such file or directory", __LINE__); return false; } $info = backup_copy($free->WORKING_DIRECTORY, "{$DestinationPath}", $ID); backup_events($ID, $servername, "INFO,{$free->WORKING_DIRECTORY}\n{$info}", __LINE__); if ($free->mysql_database != null) { $q = new mysql(); if ($free->mysql_instance_id > 0) { $q = new mysql_multi($free->mysql_instance_id); } if (!$q->DATABASE_EXISTS($free->mysql_database)) { backup_events($ID, $servername, "ERROR,{$free->mysql_database} no such database", __LINE__); $date_end = time(); $calculate = distanceOfTimeInWords($date_start, $date_end); backup_events($ID, $servername, "INFO, time: {$calculate}", __LINE__); return; } backup_mysql_database_mysqldump($ID, $free->mysql_database, "{$GLOBALS["MOUNTED_PATH_FINAL"]}/freewebs/{$servername}/MySQL", $free->mysql_instance_id); } $date_end = time(); $calculate = distanceOfTimeInWords($date_start, $date_end); backup_events($ID, $servername, "INFO, time: {$calculate}", __LINE__); }
function backup_mysql($ID) { $sock = new sockets(); $unix = new unix(); $date_start = time(); $mysqlhotcopy = $unix->find_program("mysqlhotcopy"); if ($mysqlhotcopy == null) { backup_events($ID, "mysql", "ERROR, unable to stat mysqlhotcopy"); return false; } $array = backup_mysql_databases_list($ID); if (!is_array($array)) { backup_events($ID, "mysql", "ERROR, unable to get databases list"); return false; } $q = new mysql(); if ($q->mysql_password != null) { $password = "******"; } if ($q->mysql_admin != null) { $user = "******"; } $temporarySourceDir = $sock->GET_INFO("ExecBackupTemporaryPath"); if ($temporarySourceDir == null) { $temporarySourceDir = "/home/mysqlhotcopy"; } $temporarySourceDir = "{$temporarySourceDir}/mysql"; @mkdir($temporarySourceDir, 0666, true); if (!is_dir($temporarySourceDir)) { backup_events($ID, "mysql", "ERROR, {$temporarySourceDir} permission denied or no such file or directory"); return; } backup_events($ID, "mysql", "INFO, using {$temporarySourceDir} for temp backup"); while (list($num, $line) = each($array)) { if (trim($line) == null) { continue; } backup_events($ID, "mysql", "INFO, mysqlhotcopy ({$line}) -> {$temporarySourceDir}"); unset($results); exec("{$mysqlhotcopy} --addtodest{$user}{$password} {$line} {$temporarySourceDir} 2>&1", $results); while (list($num_line, $evenement) = each($results)) { if (preg_match("#No space left on device#", $evenement)) { backup_events($ID, "mysql", "ERROR, backup No space left on device ({$temporarySourceDir})\n" . implode("\n", $results)); if (is_dir($temporarySourceDir)) { shell_exec("/bin/rm -rf {$temporarySourceDir}/*"); } return; } } backup_events($ID, "mysql", "INFO, backup {$line}\n" . implode("\n", $results)); if (strtolower($line) == "zarafa") { backup_mysql_database_mysqldump($ID, "zarafa", $temporarySourceDir); } } backup_events($ID, "mysql", "INFO, Send mysql backup to the \n" . implode("\n", $results)); backup_mkdir("{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql"); backup_copy("{$temporarySourceDir}/*", "mysql", $ID); backup_events($ID, "mysql", "INFO, backup remove content of {$temporarySourceDir}/*"); if (is_dir($temporarySourceDir)) { shell_exec("/bin/rm -rf {$temporarySourceDir}/*"); } backup_events($ID, "mysql", "INFO, backup END without known error"); $date_end = time(); $calculate = distanceOfTimeInWords($date_start, $date_end); backup_events($ID, "mysql", "INFO, time: {$calculate}"); }