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(';
