Project

General

Profile

« Previous | Next » 

Revision 1289

Added by kweitzel almost 15 years ago

Branch 2.8.1 merged back into Trunk

View differences:

backup-sql.php
1
<?php
2

  
3
// $Id$
4

  
5
/*
6

  
7
 Website Baker Project <http://www.websitebaker.org/>
8
 Copyright (C) 2004-2009, Ryan Djurovich
9

  
10
 Website Baker is free software; you can redistribute it and/or modify
11
 it under the terms of the GNU General Public License as published by
12
 the Free Software Foundation; either version 2 of the License, or
13
 (at your option) any later version.
14

  
15
 Website Baker is distributed in the hope that it will be useful,
16
 but WITHOUT ANY WARRANTY; without even the implied warranty of
17
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18
 GNU General Public License for more details.
19

  
20
 You should have received a copy of the GNU General Public License
21
 along with Website Baker; if not, write to the Free Software
22
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
23

  
24
*/
25

  
26
// Filename to use
27
$filename = $_SERVER['HTTP_HOST'].'-backup-'.gmdate('Y-m-d', time()+TIMEZONE).'.sql';
28

  
29
// Check if user clicked on the backup button
30
if(!isset($_POST['backup'])){ 
31
	header('Location: ../');
32
	exit(0);
33
} 
34
	 
35
// Include config
36
require_once('../../config.php');
37

  
38
// Begin output var
39
$output = "".
40
"#\n".
41
"# Website Baker ".WB_VERSION." Database Backup\n".
42
"# ".WB_URL."\n".
43
"# ".gmdate(DATE_FORMAT, time()+TIMEZONE).", ".gmdate(TIME_FORMAT, time()+TIMEZONE)."\n".
44
"#".
45
"\n";
46

  
47
// Get table names
48
// Use this one for ALL tables in DB
49
$query  = "SHOW TABLES";
50

  
51
if ($_POST['tables']=='WB') {
52
	// Or use this to get ONLY wb tables
53
	$prefix=str_replace('_','\_',TABLE_PREFIX);
54
	$query = "SHOW TABLES LIKE '".$prefix."%'";
55
}
56

  
57
$result = $database->query($query);
58

  
59
// Loop through tables
60
while($row = $result->fetchRow()) { 
61
	//show sql query to rebuild the query
62
	$sql = 'SHOW CREATE TABLE '.$row[0].''; 
63
	$query2 = $database->query($sql); 
64
	// Start creating sql-backup
65
	$sql_backup ="\r\n# Create table ".$row[0]."\r\n\r\n";
66
	$out = $query2->fetchRow();
67
	$sql_backup.=$out['Create Table'].";\r\n\r\n"; 
68
	$sql_backup.="# Dump data for ".$row[0]."\r\n\r\n";
69
	// Select everything
70
	$out = $database->query('SELECT * FROM '.$row[0]); 
71
	$sql_code = '';
72
	// Loop through all collumns
73
	while($code = $out->fetchRow()) { 
74
		$sql_code .= "INSERT INTO ".$row[0]." SET "; 
75
		$numeral = 0;
76
		foreach($code as $insert => $value) {
77
			// Loosing the numerals in array -> mysql_fetch_array($result, MYSQL_ASSOC) WB hasn't? 
78
			if($numeral==1) {
79
				$sql_code.=$insert ."='".addslashes($value)."',";
80
			}
81
			$numeral = 1 - $numeral;
82
		}
83
		$sql_code = substr($sql_code, 0, -1);
84
		$sql_code.= ";\r\n";
85
	}
86
	$output .= $sql_backup.$sql_code; 
87
}
88

  
89
// Output file
90
header('Content-Type: text/html');
91
header('Content-Disposition: attachment; filename='.$filename);
92
echo $output;
93

  
1
<?php
2
/**
3
 *
4
 * @category        modules
5
 * @package         backup
6
 * @author          WebsiteBaker Project
7
 * @copyright       2004-2009, Ryan Djurovich
8
 * @copyright       2009-2010, Website Baker Org. e.V.
9
 * @link			http://www.websitebaker2.org/
10
 * @license         http://www.gnu.org/licenses/gpl.html
11
 * @platform        WebsiteBaker 2.8.x
12
 * @requirements    PHP 4.3.4 and higher
13
 * @version         $Id$
14
 * @filesource		$HeadURL$
15
 * @lastmodified    $Date$
16
 *
17
*/
18

  
19
// Filename to use
20
$filename = $_SERVER['HTTP_HOST'].'-backup-'.gmdate('Y-m-d', time()+TIMEZONE).'.sql';
21

  
22
// Check if user clicked on the backup button
23
if(!isset($_POST['backup'])){
24
	header('Location: ../');
25
	exit(0);
26
}
27

  
28
// Include config
29
require_once('../../config.php');
30

  
31
// Begin output var
32
$output = "".
33
"#\n".
34
"# Website Baker ".WB_VERSION." Database Backup\n".
35
"# ".WB_URL."\n".
36
"# ".gmdate(DATE_FORMAT, time()+TIMEZONE).", ".gmdate(TIME_FORMAT, time()+TIMEZONE)."\n".
37
"#".
38
"\n";
39

  
40
// Get table names
41
// Use this one for ALL tables in DB
42
$query  = "SHOW TABLES";
43

  
44
if ($_POST['tables']=='WB') {
45
	// Or use this to get ONLY wb tables
46
	$prefix=str_replace('_','\_',TABLE_PREFIX);
47
	$query = "SHOW TABLES LIKE '".$prefix."%'";
48
}
49

  
50
$result = $database->query($query);
51

  
52
// Loop through tables
53
while($row = $result->fetchRow()) {
54
	//show sql query to rebuild the query
55
	$sql = 'SHOW CREATE TABLE '.$row[0].''; 
56
	$query2 = $database->query($sql); 
57
	// Start creating sql-backup
58
	$sql_backup ="\r\n# Create table ".$row[0]."\r\n\r\n";
59
	$out = $query2->fetchRow();
60
	$sql_backup.=$out['Create Table'].";\r\n\r\n"; 
61
	$sql_backup.="# Dump data for ".$row[0]."\r\n\r\n";
62
	// Select everything
63
	$out = $database->query('SELECT * FROM '.$row[0]); 
64
	$sql_code = '';
65
	// Loop through all collumns
66
	while($code = $out->fetchRow()) { 
67
		$sql_code .= "INSERT INTO ".$row[0]." SET "; 
68
		$numeral = 0;
69
		foreach($code as $insert => $value) {
70
			// Loosing the numerals in array -> mysql_fetch_array($result, MYSQL_ASSOC) WB hasn't? 
71
			if($numeral==1) {
72
				$sql_code.=$insert ."='".addslashes($value)."',";
73
			}
74
			$numeral = 1 - $numeral;
75
		}
76
		$sql_code = substr($sql_code, 0, -1);
77
		$sql_code.= ";\r\n";
78
	}
79
	$output .= $sql_backup.$sql_code; 
80
}
81

  
82
// Output file
83
header('Content-Type: text/html');
84
header('Content-Disposition: attachment; filename='.$filename);
85
echo $output;
86

  
94 87
?>
95 88

  

Also available in: Unified diff