class DBRestore extends DBBackup { protected function LogInfo($sMsg) { //IssueLog::Info('non juste info: '.$sMsg); } protected function LogError($sMsg) { IssueLog::Error($sMsg); } protected function LoadDatabase($sDataFile) { $this->LogInfo("Loading data onto $this->sDBHost/$this->sDBName(suffix:'$this->sDBSubName')"); // Just to check the connection to the DB (more accurate than getting the retcode of mysql) $oMysqli = $this->DBConnect(); $sHost = self::EscapeShellArg($this->sDBHost); $sUser = self::EscapeShellArg($this->sDBUser); $sPwd = self::EscapeShellArg($this->sDBPwd); $sDBName = self::EscapeShellArg($this->sDBName); if (empty($this->sMySQLBinDir)) { $sMySQLExe = 'mysql'; } else { $sMySQLExe = '"'.$this->sMySQLBinDir.'/mysql"'; } if (is_null($this->iDBPort)) { $sPortOption = ''; } else { $sPortOption = '--port='.$this->iDBPort.' '; } $sDataFileEscaped = self::EscapeShellArg($sDataFile); $sCommand = "$sMySQLExe --default-character-set=utf8 --host=$sHost $sPortOption --user=$sUser --password=$sPwd $sDBName <$sDataFileEscaped 2>&1"; $sCommandDisplay = "$sMySQLExe --default-character-set=utf8 --host=$sHost $sPortOption --user=xxxx --password=xxxx $sDBName <$sDataFileEscaped 2>&1"; // Now run the command for real $this->LogInfo("Executing command: $sCommandDisplay"); $aOutput = array(); $iRetCode = 0; exec($sCommand, $aOutput, $iRetCode); foreach($aOutput as $sLine) { $this->LogInfo("mysql said: $sLine"); } if ($iRetCode != 0) { $this->LogError("Failed to execute: $sCommandDisplay. The command returned:$iRetCode"); foreach($aOutput as $sLine) { $this->LogError("mysql said: $sLine"); } if (count($aOutput) == 1) { $sMoreInfo = trim($aOutput[0]); } else { $sMoreInfo = "Check the log file '".realpath(APPROOT.'/log/error.log')."' for more information."; } throw new BackupException("Failed to execute mysql: ".$sMoreInfo); } } public function RestoreFromZip($sZipFile, $sEnvironment = 'production') { $this->LogInfo("Starting restore of ".basename($sZipFile)); $oZip = new ZipArchiveEx(); $res = $oZip->open($sZipFile); // Load the database // $sDataDir = tempnam(SetupUtils::GetTmpDir(), 'itop-'); unlink($sDataDir); // I need a directory, not a file... SetupUtils::builddir($sDataDir); // Here is the directory $oZip->extractTo($sDataDir, 'itop-dump.sql'); $sDataFile = $sDataDir.'/itop-dump.sql'; $this->LoadDatabase($sDataFile); unlink($sDataFile); // Update the code // $sDeltaFile = APPROOT.'data/'.$sEnvironment.'.delta.xml'; if ($oZip->locateName('delta.xml') !== false) { // Extract and rename delta.xml => .delta.xml; file_put_contents($sDeltaFile, $oZip->getFromName('delta.xml')); } else { @unlink($sDeltaFile); } if (is_dir(APPROOT.'data/production-modules/')) { SetupUtils::rrmdir(APPROOT.'data/production-modules/'); } if ($oZip->locateName('production-modules/') !== false) { $oZip->extractDirTo(APPROOT.'data/', 'production-modules/'); } $sConfigFile = APPROOT.'conf/'.$sEnvironment.'/config-itop.php'; @chmod($sConfigFile, 0770); // Allow overwriting the file $oZip->extractTo(APPROOT.'conf/'.$sEnvironment, 'config-itop.php'); @chmod($sConfigFile, 0444); // Read-only $oEnvironment = new RunTimeEnvironment($sEnvironment); $oEnvironment->CompileFrom($sEnvironment); } }