public function process() { if (!is_writable(WPSQT_DIR . 'db-backups')) { echo '<div class="error">The backup folder <strong>wp-content/plugins/wp-survey-and-quiz-tool/db-backups</strong> is not writable or doesn\'t exist, please create this folder or change it\'s permissions to <strong>777</strong>.</div>'; $this->_pageVars['dirwriteable'] = false; } if ($_SERVER['REQUEST_METHOD'] == "POST" && !empty($_POST['host']) && !empty($_POST['user']) && !empty($_POST['pass']) && !empty($_POST['database'])) { $tables = array(WPSQT_TABLE_QUIZ_SURVEYS, WPSQT_TABLE_SECTIONS, WPSQT_TABLE_QUESTIONS, WPSQT_TABLE_FORMS, WPSQT_TABLE_RESULTS, WPSQT_TABLE_SURVEY_CACHE); require_once 'backupfunction.php'; $sql = backup_tables($_POST['host'], $_POST['user'], $_POST['pass'], $_POST['database'], $tables); file_put_contents(WPSQT_DIR . 'db-backups/db-' . date('His-dmy') . '.sql', $sql); $this->_pageView = "admin/maintenance/backupdone.php"; } else { $this->_pageView = "admin/maintenance/backup.php"; } }
<?php session_start(); if (!isset($_SESSION['admin'])) { exit(header("location:index.php")); } else { include "conn.php"; $pos = "Administrator"; } backup_tables('localhost', 'root', '', 'user'); /* backup the db OR just a table */ $host = 'localhost'; $user = '******'; $pass = ''; $name = 'thesis'; function backup_tables($host, $user, $pass, $name, $tables = '*') { $link = mysql_connect("localhost", "root", ""); mysql_select_db('thesis', $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } foreach ($tables as $table) { $result = mysql_query("SELECT * FROM {$table}");
<?php /* $Id: PcTypeTabs.php 3924 2010-09-30 15:10:30Z tim_schofield $ */ $PageSecurity = 15; include 'includes/session.inc'; $title = _('Insert Marks'); include 'includes/header.inc'; backup_tables('localhost', 'elly', 'masinde', '*', $db); /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $tables = '*', $db) { //get all of the tables if ($tables == '*') { $tables = array(); $result = DB_query('SHOW TABLES', $db); while ($row = DB_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = DB_query('SELECT * FROM ' . $table, $db); $num_fields = DB_num_fields($result); $num_rows = DB_num_rows($result); $return .= 'DROP TABLE IF EXISTS ' . $table . ';'; $row2 = DB_fetch_row(DB_query('SHOW CREATE TABLE ' . $table, $db)); $return .= "\n\n" . $row2[1] . ";\n\n"; $return .= 'INSERT INTO ' . $table . ' VALUES'; for ($i = 0; $i < $num_fields; $i++) {
$api->update_data('register', $v); $api->logs($TEXT['Users system has been updated']); header('Location: admin_main.php?mode=settings&submode=about&success=system'); break; case 'dropusers': $api->drop_table("users"); $api->logs($TEXT['Users table has been truncated']); header('Location: admin_main.php?mode=settings&submode=about&success=dropusers'); break; case 'droptickets': $api->drop_table("tickets"); $api->logs($TEXT['Tickets table has been truncated']); header('Location: admin_main.php?mode=settings&submode=about&success=droptable'); break; case 'backup': backup_tables(); break; case 'newdep': $api->add_department($_POST[title]); $api->logs($TEXT['New department created']); header('Location: admin_main.php?mode=settings&submode=departments&success=newdep'); break; case 'deletedep': $api->delete_department($_POST['delete']); $api->logs($TEXT['Department deleted'] . ": " . $api->sql_escape($_POST[delete])); header('Location: admin_main.php?mode=settings&submode=departments&success=deletedep'); break; case 'langs': $query = $api->get_langs(); while ($l = mysqli_fetch_array($query)) { if ($_POST[$l[short]]) {
$c = backup_tables("{$_GET['table']}", '../../../../.backup/.table', "{$file}", true); if ($c) { $size = format_size(filesize("../../../../.backup/.table/{$file}.sql")); $time = date("Y/m/d H:i:s", filemtime("../../../../.backup/.table/{$file}.sql")); $r = "{$size} - {$time}"; echo "{ \"file\":\"{$file}.sql\" , \"info\":\"{$r}\" }"; } } if ($_GET['type'] == 'installer') { @unlink("../../../../.backup/{$_GET['file']}"); $file = '../../../../system/installer.zip'; extractZip($file, '../../../../system'); if (!file_exists('../../../../.backup')) { mkdir('../../../../.backup'); } backup_tables('*', '../../../../system/installer', 'data', true); archiveZip('../../../../system/installer', '../../../../system/installer.zip'); $date = md5(date("Ymd:His")); $file = "installer-backup-{$date}.zip"; $c = archiveZip('../../../../', "../../../../.backup/{$file}"); if ($c) { $size = format_size(filesize("../../../../.backup/{$file}")); $time = date("Y/m/d H:i:s", filemtime("../../../../.backup/{$file}")); $r = "{$size} - {$time}"; echo "{ \"file\":\"{$file}\" , \"info\":\"{$r}\" }"; } } if ($_GET['type'] == 'delete') { if ($_GET['act'] == 'installer' || $_GET['act'] == 'db') { @unlink("../../../../.backup/{$_GET['file']}"); }
// for compression format, we add extension $compression = GETPOST('compression') ? GETPOST('compression', 'alpha') : 'none'; if ($compression == 'gz') { $outputfile .= '.gz'; } if ($compression == 'bz') { $outputfile .= '.bz2'; } $outputerror = $outputfile . '.err'; dol_mkdir($conf->admin->dir_output . '/backup'); if ($compression == 'gz' or $compression == 'bz') { backup_tables($outputfiletemp); dol_compress_file($outputfiletemp, $outputfile, $compression); unlink($outputfiletemp); } else { backup_tables($outputfile); } $_SESSION["commandbackuplastdone"] = ""; $_SESSION["commandbackuptorun"] = ""; } // POSTGRESQL if ($what == 'postgresql') { $cmddump = GETPOST("postgresqldump"); // Do not sanitize here with 'alpha', will be sanitize later by escapeshellarg if ($cmddump) { dolibarr_set_const($db, 'SYSTEMTOOLS_POSTGRESQLDUMP', $cmddump, 'chaine', 0, '', $conf->entity); } $outputdir = $conf->admin->dir_output . '/backup'; $outputfile = $outputdir . '/' . $file; // for compression format, we add extension $compression = GETPOST('compression') ? GETPOST('compression', 'alpha') : 'none';
<? include "../../../classes/Database.php"; include "../../../classes/Connection.php"; include "../../../classes/AdminAction.php"; include_once "../../../includes/bootstrap.php"; ?> <? backup_tables('dnradmin.db.3506263.hostedresource.com','dnradmin','DSAre96FGdd','dnradmin'); /* backup the db OR just a table */ function backup_tables($host,$user,$pass,$name,$tables = '*') { $link = mysql_connect($host,$user,$pass); mysql_select_db($name,$link); //get all of the tables if($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); }
<?php backup_tables('localhost', 'root', '', 'avijatry'); /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $name, $tables = '*') { $return = ""; $link = mysql_connect($host, $user, $pass); mysql_select_db($name, $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = mysql_query('SELECT * FROM ' . $table); $num_fields = mysql_num_fields($result); $return .= 'DROP TABLE ' . $table . ';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table)); $return .= "\n\n" . $row2[1] . ";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while ($row = mysql_fetch_row($result)) { $return .= 'INSERT INTO ' . $table . ' VALUES('; for ($j = 0; $j < $num_fields; $j++) { $row[$j] = addslashes($row[$j]);
} if ($_GET['do'] == 'download') { if ($_GET['file'] && file_exists(_BACKUP . $_GET['file'])) { if ($fp = fopen(_BACKUP . $_GET['file'], 'rb')) { $buffer = fread($fp, filesize(_BACKUP . $_GET['file'])); fclose($fp); header('Content-type: application/x-octet-stream'); header('Content-disposition: attachment; filename=' . $_GET['file']); echo $buffer; exit; } } $hook->redirect('./?mod=' . $system->module . '&act=' . $system->action); } if ($_POST) { $backup_file = backup_tables(_BACKUP, $cfg['server'], $cfg['port'], $cfg['usr'], $cfg['psw'], $cfg['name']); if ($_POST['download_only']) { header('Content-type: application/x-octet-stream'); header('Content-disposition: attachment; filename=' . $backup_file); readfile(_BACKUP . $backup_file); unlink(_BACKUP . $backup_file); exit; } $hook->redirect('./?mod=' . $system->module . '&act=' . $system->action); } if ($_GET['do'] == 'new') { $tpl->setfile(array('body' => 'tools.' . $system->action . '.new.tpl')); } else { $tpl->setfile(array('body' => 'tools.' . $system->action . '.tpl')); $dir = dir(_BACKUP); $contents = array();
echo "<script>alert('No se pudo descargar')</script>"; } } /* verifcamos si se hace una peticion de descarga de una base de datos mysql */ if (isset($_GET['descargar_bd'])) { /* verificamos que el nombre de la base de datos a descargar sea distinto de vacio */ if ($_GET['descargar_bd'] != "") { /* si se cumple la condicion, guardamos los datos en variables */ $valor = $_GET['descargar_bd']; $host = $_GET['host']; $usuario = $_GET['usuario']; $clave = $_GET['clave']; $tipo = $_GET['bd']; $base = $_GET['base']; $sql = $_GET['sql']; backup_tables($host, $usuario, $clave, $valor); } } /* verifcamos si se hace una peticion de descarga de una base de datos mysqli */ if (isset($_GET['descargar_bdi'])) { /* verificamos que el nombre de la base de datos a descargar sea distinto de vacio */ if ($_GET['descargar_bdi'] != "") { /* si se cumple la condicion, guardamos los datos en variables */ $valor = $_GET['descargar_bdi']; $host = $_GET['host']; $usuario = $_GET['usuario']; $clave = $_GET['clave']; $tipo = $_GET['bd']; $base = $_GET['base']; $sql = $_GET['sql']; backup_tables_mysqli($host, $usuario, $clave, $valor);
<?php //http://www.cristalab.com/tutoriales/respaldar-base-de-datos-mysql-usando-php-c98522l/ backup_tables('servidor', 'usuario', 'contrasena', 'bd'); /* backup the db OR just a table */ //En la variable $talbes puedes agregar las tablas especificas separadas por comas: //profesor,estudiante,clase //O d�jalo con el asterisco '*' para que se respalde toda la base de datos function backup_tables($host, $user, $pass, $name, $tables = '*') { $link = mysql_connect($host, $user, $pass); mysql_select_db($name, $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = mysql_query('SELECT * FROM ' . $table); $num_fields = mysql_num_fields($result); $return .= 'DROP TABLE IF EXISTS ' . $table . ';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table)); $return .= "\n\n" . $row2[1] . ";\n\n"; //Comprobar que no es una vista if (strpos($row2[1], 'ALGORITHM') == false) {
function convert_users_tables() { if (isset($_POST['merge_users'])) { $error = array(); foreach ($_FILES as $key => $value) { if ($value['type'] == 'application/sql' && $value['error'] == 0 || $value['type'] == '' && $key != "joomla_db") { if (!empty($value['name'])) { $files[$key] = $value; } else { switch ($key) { case 'wp_db_user': $err["other"] = 'Incorrect files from field wordpress users table'; break; case 'wp_db_usermeta': $err["other"] = 'Incorrect files from field wordpress usermeta table'; break; } } } else { $error[$key] = $value['name'] . " is incorrect file"; } } if (count($files) == 2) { $error["other"] = $err["other"]; } if (count($error) > 0) { $_SESSION['file_uploads'] = $error; } else { $_SESSION['files'] = $files; $upload_dir = PATH_TO_DIR . '/uploads/tables_' . session_id(); foreach ($files as $key => $value) { $tmp_name = $_FILES[$key]["tmp_name"]; if (!file_exists($upload_dir)) { mkdir($upload_dir); } move_uploaded_file($tmp_name, $upload_dir . '/' . $key . '.sql'); $sqlfile = file($upload_dir . '/' . $key . '.sql'); foreach ($sqlfile as $str => $string) { if (substr($string, 0, 26) == "CREATE TABLE IF NOT EXISTS") { $sqlfile[$str] = "CREATE TABLE IF NOT EXISTS `" . $key . '_' . session_id() . "` ("; } if (substr($string, 0, 11) == "INSERT INTO") { $sqlfile[$str] = preg_replace('~\\INSERT INTO `.*?\\`~', 'INSERT INTO `' . $key . '_' . session_id() . '`', $string); } if ($string == "ALTER TABLE `wp_users`") { $sqlfile[$str] = "ALTER TABLE `" . $key . '_' . session_id() . "` ("; } if ($string == "ALTER TABLE `wp_usermeta`") { $sqlfile[$str] = "ALTER TABLE `" . $key . '_' . session_id() . "` ("; } } $newSQL = fopen($upload_dir . '/' . $key . '.sql', 'w'); fwrite($newSQL, implode($sqlfile)); fclose($newSQL); $a = file($upload_dir . '/' . $key . '.sql'); foreach ($a as $n => $l) { if (substr($l, 0, 2) == '--') { unset($a[$n]); } } $a = explode(";\n", implode("\n", $a)); unset($a[count($a) - 1]); foreach ($a as $q) { if ($q) { if (!mysql_query($q)) { } } } } $wp_users = "CREATE TABLE IF NOT EXISTS `wp_users_" . session_id() . "` (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `ID` bigint(20) unsigned NOT NULL,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_login` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_pass` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_nicename` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_url` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_activation_key` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_status` int(11) NOT NULL DEFAULT '0',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `display_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; mysql_query($wp_users); $wp_users_alter = "ALTER TABLE `wp_users_" . session_id() . "`\n\t\t\t\t\t\t\t ADD PRIMARY KEY (`ID`),\n\t\t\t\t\t\t\t ADD KEY `user_login_key` (`user_login`),\n\t\t\t\t\t\t\t ADD KEY `user_nicename` (`user_nicename`);"; mysql_query($wp_users_alter); $wp_users_alter_2 = "ALTER TABLE `wp_users_" . session_id() . "`\n \t\t\t\t\t\t\t\tMODIFY `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;"; mysql_query($wp_users_alter_2); $wp_usermeta = "CREATE TABLE IF NOT EXISTS `wp_usermeta_" . session_id() . "` (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `umeta_id` bigint(20) unsigned NOT NULL,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `meta_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t `meta_value` longtext COLLATE utf8_unicode_ci\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"; mysql_query($wp_usermeta); $wp_usermeta_alter = "ALTER TABLE `wp_usermeta_" . session_id() . "`\n\t\t\t\t\t\t\t\t ADD PRIMARY KEY (`umeta_id`),\n\t\t\t\t\t\t\t\t ADD KEY `user_id` (`user_id`),\n\t\t\t\t\t\t\t\t ADD KEY `meta_key` (`meta_key`(191));"; mysql_query($wp_usermeta_alter); $wp_usermeta_alter_2 = "ALTER TABLE`wp_usermeta_" . session_id() . "`\n \t\t\t\t\t\t\t\t\tMODIFY `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;"; mysql_query($wp_usermeta_alter_2); foreach ($files as $key => $value) { $query = "SELECT * FROM `" . $key . '_' . session_id() . "`"; $result = mysql_query($query); $i = 1; while ($data = mysql_fetch_assoc($result)) { if ($key == "joomla_db") { $wp_users_joomla[$i] = $data; } elseif ($key == "wp_db_user") { $wp_users_wp[$i] = $data; } elseif ($key == "wp_db_usermeta") { $wp_db_usermeta[$i] = $data; } $i++; } $query = "DROP TABLE `" . $key . '_' . session_id() . "`"; mysql_query($query); } foreach ($wp_users_joomla as $num => $value) { @($users[$num]['wp_users']['ID'] = $num); @($users[$num]['wp_users']["user_login"] = $value['username']); @($users[$num]['wp_users']["user_pass"] = $value['password']); @($users[$num]['wp_users']["user_nicename"] = $value['name']); @($users[$num]['wp_users']["user_email"] = $value['email']); @($users[$num]['wp_users']["user_url"] = ''); @($users[$num]['wp_users']["user_registered"] = $value['registerDate']); @($users[$num]['wp_users']["user_activation_key"] = ''); @($users[$num]['wp_users']["user_status"] = "0"); @($users[$num]['wp_users']["display_name"] = $value['name']); @($users[$num]['wp_usermeta']["nickname"] = $value['username']); @($users[$num]['wp_usermeta']["first_name"] = substr($value['name'], 0, strpos($value['name'], " "))); @($users[$num]['wp_usermeta']["last_name"] = substr($value['name'], strpos($value['name'], " "))); @($users[$num]['wp_usermeta']["description"] = ''); @($users[$num]['wp_usermeta']["rich_editing"] = 'true'); @($users[$num]['wp_usermeta']["comment_shortcuts"] = 'false'); @($users[$num]['wp_usermeta']["admin_color"] = 'fresh'); @($users[$num]['wp_usermeta']["use_ssl"] = '-'); @($users[$num]['wp_usermeta']["show_admin_bar_front"] = 'false'); @($users[$num]['wp_usermeta']["wp_capabilities"] = 'a:1:{s:8:"customer";b:1:}'); @($users[$num]['wp_usermeta']["wp_user_level"] = '0'); @($users[$num]['wp_usermeta']["dismissed_wp_pointers"] = ''); @($users[$num]['wp_usermeta']["author_facebook"] = ''); @($users[$num]['wp_usermeta']["author_custom"] = ''); @($users[$num]['wp_usermeta']["author_gplus"] = ''); @($users[$num]['wp_usermeta']["author_dribble"] = ''); @($users[$num]['wp_usermeta']["author_linkedin"] = ''); @($users[$num]['wp_usermeta']["author_twitter"] = ''); } foreach ($wp_users_wp as $numb => $value) { @($wp[$numb]['wp_users']['ID'] = $numb); @($wp[$numb]['wp_users']["user_login"] = $value['user_login']); @($wp[$numb]['wp_users']["user_pass"] = $value['user_pass']); @($wp[$numb]['wp_users']["user_nicename"] = $value['user_nicename']); @($wp[$numb]['wp_users']["user_email"] = $value['user_email']); @($wp[$numb]['wp_users']["user_url"] = $value["user_url"]); @($wp[$numb]['wp_users']["user_registered"] = $value['user_registered']); @($wp[$numb]['wp_users']["user_activation_key"] = $value["user_activation_key"]); @($wp[$numb]['wp_users']["user_status"] = $value["user_status"]); @($wp[$numb]['wp_users']["display_name"] = $value['display_name']); } foreach ($wp_db_usermeta as $idmeta => $value) { @($wp[$value['user_id']]['wp_usermeta'][$value['meta_key']] = $value['meta_value']); } $allusers = array_merge($users, $wp); echo "<pre>"; // var_dump($allusers); echo "</pre>"; $i = 1; foreach ($allusers as $key => $value) { $tables[$i] = $value; $i++; } foreach ($tables as $key => $value) { foreach ($value as $wp => $val) { if ($wp == "wp_users") { $query = "INSERT INTO `wp_users_" . session_id() . "` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES\n\t\t\t\t\t\t\t ('" . $val["ID"] . "', '" . $val["user_login"] . "', '" . $val["user_pass"] . "', '" . $val["user_nicename"] . "', '" . $val["user_email"] . "', '" . $val["user_url"] . "', '" . $val["user_registered"] . "', '" . $val["user_activation_key"] . "', '" . $val["user_status"] . "', '" . $val["display_name"] . "')"; $result = mysql_query($query); } elseif ($wp == "wp_usermeta") { foreach ($val as $meta_key => $data) { $query = "INSERT INTO `wp_usermeta_" . session_id() . "` (`user_id`, `meta_key`, `meta_value`) VALUES('" . $key . "', '" . $meta_key . "', '" . $data . "')"; $result = mysql_query($query); } } } } $backup_file = $upload_dir . '/wp_users_' . session_id() . '.sql'; $mybackup = backup_tables(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, "wp_users_" . session_id()); $handle = fopen($backup_file, 'w+'); fwrite($handle, $mybackup); fclose($handle); $query = "DROP TABLE `wp_users_" . session_id() . "`"; mysql_query($query); $backup_file = $upload_dir . '/wp_usermeta_' . session_id() . '.sql'; $mybackup = backup_tables(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, "wp_usermeta_" . session_id()); $handle = fopen($backup_file, 'w+'); fwrite($handle, $mybackup); fclose($handle); $query = "DROP TABLE `wp_usermeta_" . session_id() . "`"; mysql_query($query); } } }
<?php //backup_tables('localhost','username','password','blog'); backup_tables('localhost', 'root', '', 'salesfinder'); /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $name, $tables = '*') { $link = mysql_connect($host, $user, $pass); mysql_select_db($name, $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = mysql_query('SELECT * FROM ' . $table); $num_fields = mysql_num_fields($result); $return .= 'DROP TABLE ' . $table . ';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table)); $return .= "\n\n" . $row2[1] . ";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while ($row = mysql_fetch_row($result)) { $return .= 'INSERT INTO ' . $table . ' VALUES('; for ($j = 0; $j < $num_fields; $j++) { $row[$j] = addslashes($row[$j]);
echo "</div><br />"; while ($r3o = mysql_fetch_assoc($sql)) { $email = $r3o['email']; $date = $r3o['date']; $message = $r3o['message']; echo "<div class='tmp'><table cellpadding='0' align='center' width='70%' >"; echo "<tr><td>email : {$email} </td><td>date : {$date} </td></tr>\r\n<tr > <td>message</td> <td colspan='2'>{$message}</td><br /><br /></tr>"; echo "</table></div>"; echo "<br /><a href='{$pg}?sws=ms&show=tb'>[ Back ]</a>"; exit; } } else { if ($op == 'bkup') { if (isset($_POST['viw'])) { $path = $_POST['path']; $domp = @backup_tables($path, $host_c, $user_c, $pass_c, $db_c); echo "<center><br /><div style=\"color: #003300; font-weight: bold\">Create backup successfully <br /><br /> {$path}</div> </center>"; echo "<br /><a href='{$pg}?sws=ms&show=tb'>[ Back ]</a>"; exit; } else { echo '<form method="post"> <br /><br /> path backup <br /><br /><input type="text" name="path" /><br /><br /> <input type="submit" name="viw" value="Create" /> </form>'; exit; } } else { if ($op == 'sh3') { if (isset($_POST['viw'])) {
</h3> <table cellpadding="0" cellspacing="0"> <td><?php // Include settings include "config.php"; // Set the suffix of the backup filename if ($table == '*') { $extname = 'all'; } else { $extname = str_replace(",", "_", $table); $extname = str_replace(" ", "_", $extname); } $here = dirname(__FILE__) . DS; // Generate the filename for the backup file $index1 = $here . 'backup' . DS . 'index.php'; $filess = $here . 'backup' . DS . 'dbbackup_' . date("d.m.Y_H_i_s") . uniqid() . '_' . $extname; touch($filess); touch($index1); // Call the backup function for all tables in a DB backup_tables($DBhost, $DBuser, $DBpass, $DBName, $table, $extname, $filess); // Backup the table and save it to a sql file // Print the message print _e("The backup has been created successfully", true) . '. <br />' . _e("You can get MySQL dump file", true) . ' <a href="' . $filess . '.sql" class="view">' . _e("", true) . '</a>.<br>' . "\n"; print _e("You can get Backed-up files archive", true) . ' <a href="' . $filess . '.zip" class="view">' . _e("here", true) . '</a>.<br>' . "\n"; ?> </td> </table> <br /> </form>
function send_backup() { // send the database content to the user header("Content-Transfer-Encoding: Binary"); #header("Content-length: ".strlen($file_content)); header("Content-type: application/octet-stream"); header("Last-Modified: " . gmdate("D, d M Y H:i:s", time()) . " GMT"); if (isset($_GET["table_name"])) { // only allow basic characters in the table name. no spaces and no quotes $table_name = preg_replace("/[^a-zA-Z0-9_]+/", "", urldecode($_GET["table_name"])); header("Content-disposition: filename=\"" . SDATA_DB_NAME . "-" . date("Y-m-d", time()) . "-" . $table_name . ".sql\""); backup_tables(SDATA_DB_HOST, SDATA_DB_USER, SDATA_DB_PASS, SDATA_DB_NAME, $table_name, false); } else { header("Content-disposition: filename=\"" . SDATA_DB_NAME . "-" . date("Y-m-d", time()) . ".sql\""); backup_tables(SDATA_DB_HOST, SDATA_DB_USER, SDATA_DB_PASS, SDATA_DB_NAME, '*'); } }
function backup($pdo) { global $today; $path = 'dbbackup' . DS; $backup = backup_tables(HOST, LOGIN, PASSWORD, DATABASE); $filesize = formatbytes($path . $backup, 'KB'); $sql = "insert into backup.backup(`file`,`backupdate`,`size`) values(:b,:bd,:fs)"; $stmt = $pdo->prepare($sql); $stmt->bindvalue(':b', $backup, PDO::PARAM_STR); $stmt->bindvalue(':bd', $today, PDO::PARAM_STR); $stmt->bindvalue(':fs', $filesize, PDO::PARAM_STR); $stmt->execute(); if (is_connected()) { dropboxBackup($path . $backup, $backup); } redirect(BASE_PATH . '/backup/?token=' . $_SESSION['token'], 1); }
} elseif ($step == 'start') { $ecshop_charset = isset($_POST['ecshop_charset']) ? $_POST['ecshop_charset'] : $ecshop_charset; $mysql_charset = isset($_POST['mysql_charset']) ? $_POST['mysql_charset'] : $mysql_charset; if ($ecshop_charset == $mysql_charset) { $ext_msg = '<span style="color:red;font-size:14px;font-weight:bold">您的程序编码与数据库编码一致,无需进行转换。</span><br /><a href="index.php"><font size="2"><b>>> 如果您需要执行升级程序,请点这里进行升级</b></font></a>'; showmessage($ext_msg); } $act = getgpc('act', 'P'); if (init_convert_tables($convert_tables_file)) { include ROOT_PATH . $convert_tables_file; } else { showmessage('<span style="color:red;font-size:14px;font-weight:bold">没有数据表可以转换</span>'); } $tables_keys = array_keys($convert_tables); if (empty($act)) { $backup_count = backup_tables($tables_keys); $extra = ' <input type="hidden" name="ecshop_charset" value="' . $ecshop_charset . '" /> <input type="hidden" name="mysql_charset" value="' . $mysql_charset . '" /> <input type="hidden" name="act" value="convert" /> <input type="hidden" name="table_name" value="' . $tables_keys[0] . '" />'; showmessage("数据库备份完成," . $backup_count . " 个原数据表均重命名为以 _bak 为后缀!", '?step=start', 'form', $extra); } else { convert_table(getgpc('table_name', 'P')); } } ob_end_flush(); function instheader() { global $charset, $tools_version; echo "<html><head>" . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset={$charset}\">" . "<title>ECShop 数据库编码转换工具{$tools_version}</title>" . "<style type=\"text/css\">\n a {\n color: #3A4273;\n text-decoration: none\n }\n\n a:hover {\n color: #3A4273;\n text-decoration: underline\n }\n\n body, table, td {\n color: #3A4273;\n font-family: Tahoma, Verdana, Arial;\n font-size: 12px;\n line-height: 20px;\n scrollbar-base-color: #E3E3EA;\n scrollbar-arrow-color: #5C5C8D\n }\n form {\n margin:0;\n padding:0\n }\n input {\n color: #085878;\n font-family: Tahoma, Verdana, Arial;\n font-size: 12px;\n background-color: #3A4273;\n color: #FFFFFF;\n scrollbar-base-color: #E3E3EA;\n scrollbar-arrow-color: #5C5C8D\n }\n\n .install {\n font-family: Arial, Verdana;\n font-size: 20px;\n font-weight: bold;\n color: #000000\n }\n\n .message {\n background: #E3E3EA;\n padding: 20px;\n }\n\n .altbg1 {\n background: #E3E3EA;\n }\n\n .altbg2 {\n background: #EEEEF6;\n }\n\n .header td {\n color: #FFFFFF;\n background-color: #3A4273;\n text-align: center;\n }\n\n .option td {\n text-align: center;\n }\n\n .redfont {\n color: #FF0000;\n }\n .p_indent{\n text-indent:2em;\n }\n div.msg{\n text-indent:2em;\n line-height:30px;\n height:30px;\n }\n </style>\n <script type=\"text/javascript\">\n function redirect(url) {\n window.location=url;\n }\n function \$(id) {\n return document.getElementById(id);\n }\n </script>\n </head>" . "<body bgcolor=\"#298296\" text=\"#000000\"><div id=\"append_parent\"></div>" . "<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#FFFFFF\" align=\"center\"><tr><td>" . "<table width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tr>" . "<td class=\"install\" height=\"30\" valign=\"bottom\"><font color=\"#FF0000\">>></font> ECShop 数据库编码转换工具{$tools_version}" . "</td></tr><tr><td><hr noshade align=\"center\" width=\"100%\" size=\"1\"></td></tr><tr><td colspan=\"2\">";
<?php $cfg = (include_once 'config/config.php'); backup_tables($cfg["connect"]['host'], $cfg["connect"]['user'], $cfg["connect"]['pass'], $cfg["connect"]['db']); /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $name, $tables = '*') { $link = mysql_connect($host, $user, $pass); mysql_select_db($name, $link); mysql_query("SET NAMES utf8;"); mysql_query("SET CHARACTER_SET_CLIENT=utf8;"); mysql_query("SET CHARACTER_SET_RESULTS=utf8;"); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = mysql_query('SELECT * FROM ' . $table); $num_fields = mysql_num_fields($result); #$return.= 'DROP TABLE '.$table.';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table)); $return .= "\n\n" . $row2[1] . ";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while ($row = mysql_fetch_row($result)) {
<?php //error_reporting(0); session_start(); backup_tables('localhost', 'kashifdb', '123456', 'composeup'); //$_SESSION['check'] = "ExportSeccess"; /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $name, $tables = '*') { $link = mysql_connect($host, $user, $pass); mysql_select_db($name, $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = mysql_query('SELECT * FROM ' . $table); $num_fields = mysql_num_fields($result); $return .= 'DROP TABLE ' . $table . ';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table)); $return .= "\n\n" . $row2[1] . ";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while ($row = mysql_fetch_row($result)) { $return .= 'INSERT INTO ' . $table . ' VALUES(';
function connect() { $domain = $_SERVER['HTTP_HOST']; if ($domain == 'localhost') { $kapcsolat = mysql_connect("localhost", LOCALHOST_DB_USER, LOCALHOST_DB_PASSWORD); $adatbazis = mysql_select_db(LOCALHOST_DB_NAME); } else { $kapcsolat = mysql_connect("localhost", DOMAIN_DB_USER, DOMAIN_DB_PASSWORD); $adatbazis = mysql_select_db(DOMAIN_DB_NAME); } if (!$kapcsolat) { die('Hiba a MySQL szerverhez kapcsolódás közben: ' . mysql_error()); } $ekezet = mysql_set_charset("utf8", $kapcsolat); if ($_REQUEST[db_save]) { if (!$_REQUEST[table]) { $tables = '*'; } else { $tables = $_REQUEST[table]; } backup_tables($tables); } if ($_REQUEST[db_load]) { sql_import("db-backup.sql"); } }
while ($row = mysql_fetch_array($pena)) { echo $row["user_id"]; echo $row["category_id"]; echo $row["cat_id"]; ?> <br/> <?php } /*5-----------------------------------------------------------------------------------------*/ backup_tables('localhost', 'root', 'subd_exam_Anton', 'sub_exam_backup1'); /*6-------------------------------------------------------------------------------------------*/ mysql_query(" CREATE TABLE Article_part1 (\n\t\t\tart_part1_id INT AUTO_INCREMENT,\n\t\t\tname VARCHAR(30),\n\t\t\tPRIMARY KEY(art_part1_id))") or die(mysql_error()); mysql_query("INSERT INTO Article_part1 (name) SELECT name FROM Article"); mysql_query("ALTER TABLE Article DROP name"); mysql_query("ALTER TABLE Article RENAME TO Article_part2"); /*7--------------------------------------------------------------------------------------------*/ backup_tables('localhost', 'root', 'subd_exam_Anton', 'sub_exam_backup2'); /*8-----------------------------------------------------------------------------------------------*/ /*Which are the Tag(s) for a given Article --> tag cat art*/ $pena = mysql_query("SELECT * FROM Tag INNER JOIN Category ON Tag.tag_id = Category.tag_id \n\t\t \tINNER JOIN Article_part2 ON Article_part2.cat_id = Category.category_id\n\t\t \tINNER JOIN Article_part1 ON Article_part1.art_part1_id = Article_part2.article_id\n\t\t \t WHERE Article_part2.article_id = 1"); // SELECT 2 ?> THE ANSWER OF THE SECONT QUESTION IS : <br/><?php while ($row = mysql_fetch_array($pena)) { echo $row["article_id"]; echo $row["category_id"]; echo $row["tag_id"]; ?> <br/> <?php } ?> </body>
$row[$j] = str_replace("\n", "\\n", $row[$j]); if (isset($row[$j])) { $return .= '"' . $row[$j] . '"'; } else { $return .= '""'; } if ($j < $num_fields - 1) { $return .= ','; } } $return .= ");\n"; } } $return .= "\n\n\n"; } //save file $handle = fopen('db-backup-' . time() . '-' . md5(implode(',', $tables)) . '.sql', 'w+'); fwrite($handle, $return); fclose($handle); $zip = new ZipArchive(); $filename = './db-backup-' . time() . '-' . md5(implode(',', $tables)) . '.zip'; if ($zip->open($filename, ZipArchive::CREATE) !== TRUE) { exit("cannot open <{$filename}>\n"); } $zip->addFile($thisdir . 'db-backup-' . time() . '-' . md5(implode(',', $tables)) . '.sql'); echo "numfiles: " . $zip->numFiles . "\n"; echo "status:" . $zip->status . "\n"; $zip->close(); } backup_tables($dbhost, $dbuser, $dbpass, $dbname);
/******************************************************************************************/ /******************************************************************************************/ //SKIPJACK vertigo dev /******************************************************************************************/ /******************************************************************************************/ //SKIPJACK vertigo dev case "devtimesheet.skipjack.co.za": $database_host = 'vertigo'; $host = $database_host; $user = '******'; $pass = '******'; $dataBasename = 'skipjack_timesheet'; break; } //backup_tables('vertigo','sj_timesheet','sj_timesheet','skipjack_timesheet'); backup_tables($host, $user, $pass, $dataBasename); echo 'DB Buckup file:<br>'; echo '' . $dataBasename . '_backup-' . date('d-m-Y') . '__' . date('H-i-s') . '.sql<br>'; echo ' with success'; /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $dataBasename, $tables = '*') { $link = mysql_connect($host, $user, $pass); mysql_select_db($dataBasename, $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; }
case 'timer': timer(); break; case '1h': update_sensoren(); update_sensoren_graph_today(); update_sensoren_graph_week(); update_sensoren_graph_month(); break; case 'genGraphDay': update_sensoren_graph_today(); break; case 'genGraphWeek': update_sensoren_graph_week(); break; case 'genGraphMonth': update_sensoren_graph_month(); break; case 'midnight': calculate_sun_rise_set(); calculate_strom(); break; case 'test': update_geraete(); break; case 'backup': backup_tables($_GET['table']); break; default: break; }
<?php require 'lib/bk_zip.php'; /* include zip lib */ require 'lib/bk_db.php'; /*include export code lib*/ $name_zip_file .= date("j-n-Y"); /* get date now */ $name_zip_file .= '-user.zip'; $files_to_zip = directoryToArray('../public_html', true); /*Export DB*/ backup_tables('db_host', 'user_db', 'user_db_pass', 'db_name'); /*Zip file*/ $result = create_zip($files_to_zip, $name_zip_file); /*Transfer file via FTP */ $server = 'IP FTP'; $ftp_user_name = "Username FTP"; $ftp_user_pass = "******"; $connection = ftp_connect($server); $login = ftp_login($connection, $ftp_user_name, $ftp_user_pass); if (!$connection || !$login) { die('Connection attempt failed!'); } $upload = ftp_put($connection, $name_zip_file, $name_zip_file, FTP_ASCII); if (!$upload) { echo 'FTP upload failed!'; } ftp_close($connection); /*Delete file zip and sql after backup*/ $files_db = glob("*.sql"); foreach ($files_db as $file_db) {
<? backup_tables('127.0.0.1','root','1234','administrador'); function backup_tables($host,$user,$pass,$name,$tables = '*') { $link = mysql_connect($host,$user,$pass); mysql_select_db($name,$link); //get all of the tables if($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); } //cycle through foreach($tables as $table) { $result = mysql_query('SELECT * FROM '.$table); $num_fields = mysql_num_fields($result); $return.= 'DROP TABLE '.$table.';';
$tipeFile = getEkstensiFile($fileName); if ($tipeFile == "sql") { $move = move_uploaded_file($_FILES['restore']['tmp_name'], 'temp/' . $fileName); $rest = restore("temp/" . $fileName); unlink("temp/" . $fileName); if (!$rest) { echo "<h4 class='alert_success'>Berhasil Restore<span id='close'>[<a href='#'>X</a>]</span></h4>"; } else { echo "<h4 class='alert_error'>Gagal Restore " . mysql_error() . "<span id='close'>[<a href='#'>X</a>]</span></h4>"; } } else { echo "<h4 class='alert_error'>Bukan File SQL. Tipe file Anda : <b>{$fileType}</b><span id='close'>[<a href='#'>X</a>]</span></h4>"; } } else { if ($mod == "backup") { $bck = backup_tables("*"); echo "<meta http-equiv='refresh' content='0; url= donload.php?filename={$bck}'>"; if ($bck) { echo "<h4 class='alert_success'>Berhasil Backup<span id='close'>[<a href='#'>X</a>]</span></h4>"; } else { echo "<h4 class='alert_error'>Backup gagal<span id='close'>[<a href='#'>X</a>]</span></h4>"; } } } ?> <article class="module width_full"> <header><h3>Backup dan Restore Database</h3></header> <div class="module_content"> <h3>Backup Database</h3> <br>
//akan menelusuri setiap baris query didalam $row[$j] = addslashes($row[$j]); $row[$j] = ereg_replace("\n", "\\n", $row[$j]); if (isset($row[$j])) { $return .= '"' . $row[$j] . '"'; } else { $return .= '""'; } if ($j < $num_fields - 1) { $return .= ','; } } $return .= ");\n"; } } $return .= "\n\n\n"; } //simpan file di folder yang anda tentukan sendiri. kalo saya sech folder "DATA" $nama_file; $handle = fopen('./data_backup/' . $nama_file, 'w+'); fwrite($handle, $return); fclose($handle); } $file = date("DdMY") . 'lukstron' . time() . '.sql'; $tanggal = date('Y-m-d H:i:s'); backup_tables("localhost", "root", "", "e-pegawai", $file); mysql_query("insert into backup_data values(NULL,'{$tanggal}','{$file}')"); include "../../include/catat.php"; $user = $_SESSION['KODE_PETUGAS']; $aksi = "Melakukan pencadangan basis data"; catat($user, $aksi);
<?php error_reporting(0); //host-name,user-name,password,DB name backup_tables('localhost', '***user***', '***password***', '***database***'); /* backup the db OR just a table */ function backup_tables($host, $user, $pass, $name, $tables = '*') { $return = ""; $link = mysql_connect($host, $user, $pass); mysql_set_charset("UTF8", $link); mysql_select_db($name, $link); //get all of the tables if ($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',', $tables); } //cycle through foreach ($tables as $table) { $result = mysql_query('SELECT * FROM ' . $table); $num_fields = mysql_num_fields($result); $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table)); $return .= $row2[1] . ";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while ($row = mysql_fetch_row($result)) { $return .= 'INSERT INTO ' . $table . ' VALUES(';