function dump($argv, $argc) { global $fold, $database, $site; $fix = $argv[1]; $datestamp = date("Y-m-d_H-i-s"); $dumpFileName = /* $page['base']['href'] . */ $fold['sql'] . $database['name'] . "_$datestamp.sql"; $connection = mysql_connect($database['host'], $database['user'], $database['pass']); if (!$connection) { return "Святые одуванчики! У нас проблемы!"; } include_once $fold['classes'] . 'MySQLDump' . $site['extensions']; $dumper = new MySQLDump($database['name'], $dumpFileName, false, false); mysql_query("set names utf8"); $dumper->doDump(); if ($fix) { # фикс заменяющий неработающую CURRENT_TIMESTAMP на некоторых серверах (в частности на сервере ФС) $fileContents = file_get_contents($dumpFileName); $fileContents = str_ireplace('CURRENT_TIMESTAMP', date("Y-m-d H:i:s"), $fileContents); file_put_contents($dumpFileName, $fileContents); } return "Дамп ${mysql['db']}_$datestamp.sql успешно создан в папку дампов и бекапов \"".$fold['sql']."\". Просмотр содержимого: `get last dump`. Создание дампа с просмотром осуществляется командой get mysql dump.\n"; }
/** * Writes to file the selected database dump * * @return bool */ function doFKDump($params = array()) { parent::doDump($params, false); $this->getForeignKeys(); $sql_file = "-- ------------\n"; $sql_file .= "-- FOREIGN KEYS\n"; $sql_file .= "-- ------------\n"; $sql_file .= "SET FOREIGN_KEY_CHECKS = 0;\n\n"; $sql_file .= $this->getForeignKeysRules(); $sql_file .= "SET FOREIGN_KEY_CHECKS = 1;\n\n"; $this->saveToFile($this->file, $sql_file); $this->closeFile($this->file); return true; }
set_time_limit(0); /*** Дамп базы данных: ***/ include("../core/config/config.inc.php"); //include("class_mysqldump.php"); include("mysqldump.php"); $ready = false; if(count($_POST) && !empty($_POST["filename"])) { mysql_connect($database_server, $database_user, $database_password) or die("F*****g shit! We have troubles!"); $dumpFileName = "dumps/".$_POST["filename"].".sql"; $dumper = new MySQLDump($dbase,$dumpFileName,false,false); mysql_query("set names utf8"); @$dumper->doDump(); // фикс заменяющий неработающую CURRENT_TIMESTAMP на наших серверах $fileContents = file_get_contents($dumpFileName); $fileContents = str_ireplace('CURRENT_TIMESTAMP','0000-00-00 00:00:00',$fileContents); file_put_contents($dumpFileName , $fileContents); $ready = true; } $filename = "dump_".date("d-m-Y"); include("dumperview.php"); /*** /дамп базы данных ***/ /*** Архив сайта: ***/ $archiveDir = "archives/";
function add_sql($table) { if ($this->status != $this->cont['TARLIB_STATUS_CREATE']) { return ''; } // File is not created if (!HypCommonFunc::loadClass('MySQLDump')) { $this->func->die_message('Class "MySQLDump" was not found.'); } $db = $this->xpwiki->db; $removePrefix = $db->prefix($this->root->mydirname . '_'); $short_name = substr($table, strlen($removePrefix)); $this->dirs[] = 'DB@' . $short_name; $name = $this->cont['CACHE_DIR'] . $short_name . '.sql'; $dumper = new MySQLDump($db->conn, $name, false, false); $dumper->removePrefix = $removePrefix; $dumper->maxFileSize = $this->limitSize; //$dumper->maxFileSize = 1048576; //1M // ToDo fix notice error of "MySQLDump" class. $_error_level = error_reporting(0); $dumper->doDump($table); error_reporting($_error_level); foreach ($dumper->sqlFiles as $name) { $this->add_file($name, false, ''); } return 1; }
/** * backup elkészitése * @return void */ public function dobackup() { $session = JFactory::getSession(); $userTerhats = $session->get('userTerhats'); $jo = false; foreach ($userTerhats as $userTerhat) { if ($userTerhat->terszerv_id == 1) $jo = true; } if (!$jo) { echo '<div class="errorMs">'.JText::_('ACCESS_DENIED').'</div>'; return; } $errormsg = ''; // config.php elérése $config = &JFactory::getConfig(); // mysql connection_aborted $connection1 = @mysql_connect($config->get('host'), $config->get('user'), $config->get('password')); // dump elkészitése if ($connection1) { $results = mysql_query("SET NAMES UTF8;"); $filePath = JPATH_ROOT."/backups/".$config->get('db')."-".date('Y-m-d-H-i')."-" .rand().".sql.php"; if (file_exists($filePath)) unlink($filePath); $dumper = new MySQLDump($config->get('db'),$filePath,false,false); if (!$dumper->doDump()) $errorMsg .= "<br /> error mysql dump."; } else { $errorMsg .= "<br /> error can not connect to mysql database."; } if ($errorMsg != '') { echo '<div class="errorMsg">'.$errormsg.'</div>'; } else { echo '<div class="infoMsg"> <center> <br /><br /> <h3>'.$config->get('db')."-".date('Y-m-d-H-i').".sql".'</h3> <p>Database backup is complete</p> <br /><br /> </center> </div> <script type="text/javascript"> if (parent) { var wait = parent.document.getElementById("waiting"); if (wait) { wait.style.backgroundImage = "none"; wait.innerHTML="<h3>Az adatbázis mentés elkészült.</h3>"; } } </script> '; } }
<?php //MySQL connection parameters $dbhost = 'localhost'; $dbuser = '******'; $dbpsw = 'ppp'; $dbname = 'dynamic'; //Connects to mysql server $connessione = @mysql_connect($dbhost, $dbuser, $dbpsw); //Set encoding mysql_query("SET CHARSET utf8"); mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'"); //Includes class require_once 'FKMySQLDump.php'; //Creates a new instance of FKMySQLDump: it exports without compress and base-16 file $dumper = new MySQLDump($dbname, 'fk_dump.sql', false, false); $params = array('skip_structure' => TRUE); //Make dump $dumper->doDump($params);