Revision 1289
Added by kweitzel almost 15 years ago
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
Branch 2.8.1 merged back into Trunk