Code: Select all
function backup_all()
{
global $file_folder, $gmt;
$dateforbackup = gmdate("Y.m.d-H.i.s", mktime(date("H")+ $gmt, date("i"), date("s"), date("m"), date("d"), date("Y")));
if (isset($_POST['backup']))
{
$data = ("
###################################
##Backup de bases de datos Completo
##
##Backupdate: '$dateforbackup'
##Database: ".s('dbname')."
###################################\n
");
$tabeller = mysql_list_tables(s('dbname'));
$tab_navn = array();
for ($i = 0; $i < mysql_num_rows($tabeller); $i++) {
$tab_navn[] = mysql_tablename($tabeller, $i);
}
foreach ($tab_navn as $tabell) {
$query = mysql_query("SHOW CREATE TABLE $tabell");
$result = mysql_fetch_array($query);
$data .= ("DROP TABLE IF EXISTS $tabell ;\n");
$data .= ("$result[1];\n\n");
$felt_navn = array();
$query = mysql_query("SELECT * FROM " .s('prefix'). "$tabell");
for ($i = 0; $i < mysql_num_fields($query); $i++) {
$felt_navn[] = mysql_field_name($query, $i);
}
while($result = mysql_fetch_array($query)) {
$data .= ("INSERT INTO `$tabell` VALUES (");
foreach ($felt_navn as $felt_name) {
$result[$felt_name] = str_replace("'", "\'", $result[$felt_name]);
$data .= ("'$result[$felt_name]'");
if(next($felt_navn)) {
$data .= (", ");
}
}
$data .= (");\n");
}
mysql_free_result($query);
}
$data .= ("\n");
$filnavn = $dateforbackup."_Backup_Completo.inc";
if (!$action = fopen($file_folder."/".$filnavn, 'w')) {
print("Can not open $filnavn");
echo "<h1><a href=\"index.php?action=backup\">". l('back') ."</a></h1>";
} elseif (fwrite($action, $data) === FALSE) {
print("Can not write to $filnavn");
echo "<h1><a href=\"index.php?action=backup\">". l('back') ."</a></h1>";
} else
{
echo "<h3>".l(back_success)."<i>".s('dbname')."</i>".l(have_success)."</h3>";
echo "<h1><a href=\"index.php?action=backup\">". l('back') ."</a></h1>";
?><meta http-equiv="refresh" content="2; url=index.php?action=backup"><?
}
fclose($action);
}
}Code: Select all
###################################
##Backup de bases de datos Completo
##
##Backupdate: '2009.07.26-00.24.03'
##Database: killerkaos_news
###################################
DROP TABLE IF EXISTS articles ;
CREATE TABLE `articles` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`text` text,
`textlimit` int(5) NOT NULL default '0',
`date` datetime default NULL,
`category` int(8) NOT NULL default '0',
`position` char(3) default NULL,
`displaytitle` char(3) NOT NULL default 'YES',
`displayinfo` char(3) NOT NULL default 'YES',
`commentable` varchar(5) NOT NULL default 'YES',
`image` text NOT NULL,
`swf` varchar(30) default NULL,
`publishuser` char(3) NOT NULL default 'YES',
`postedby` int(3) NOT NULL default '0',
`materia` char(3) NOT NULL default '',
`materialogo` varchar(30) NOT NULL default '',
`private` char(3) NOT NULL default 'NO',
`lastupdate` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INTO `articles` VALUES ('1', 'Apertura', '<p>Nueva apertura de Craken.com.ar</p>', '500', '2007-09-01 21:12:16', '0', '1', 'YES', 'YES', 'YES', '', '', 'YES', '1', 'NO', '', [color=#FF0000]'NO''2009-02-28 16:38:45'[/color]);
Thanks