Ich hab ein problem beim Backupeinspielen:
Ich hab zwar versucht was zu suchen, aber nur das gefunden:
http://www.phpbb.de/viewtopic.php?t=516 ... ges+backup
Da steht dass am ende des backups
Code: Alles auswählen
# Daten für Tabelle `phpbb_words`
#
# --------------------------------------------------------
(auszug aus backup-ende)
Code: Alles auswählen
U', '3');
INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES('2', '1', 'De Maunsbüda vo Mens haben eh ka Chance [engl. ausgesprochen]', '0');
INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES('2', '2', 'De Ladies san jo nu jedes moi nach a paar Bierchen völlig parterre!', '3');
INSERT INTO phpbb_vote_results (vote_id, vote_option_id, vote_option_text, vote_result) VALUES('2', '3', 'Was i doch ned, i sauf mi nieder bis i nimma kau!', '1');
#
# TABLE: phpbb_vote_voters
#
DROP TABLE IF EXISTS phpbb_vote_voters;
CREATE TABLE phpbb_vote_voters(
vote_id mediumint(8) unsigned NOT NULL,
vote_user_id mediumint(8) NOT NULL,
vote_user_ip char(8) NOT NULL,
KEY vote_id (vote_id),
KEY vote_user_id (vote_user_id),
KEY vote_user_ip (vote_user_ip)
);
#
# Table Data for phpbb_vote_voters
#
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('1', '2', '507925f5');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('1', '3', '507925f5');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('1', '4', 'd4caedd2');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('2', '4', 'd4caedd2');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('2', '7', 'c2c39962');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('2', '3', '507925be');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('2', '5', 'd421313e');
#
# TABLE: phpbb_words
#
DROP TABLE IF EXISTS phpbb_words;
CREATE TABLE phpbb_words(
word_id mediumint(8) unsigned NOT NULL auto_increment,
word char(100) NOT NULL,
replacement char(100) NOT NULL,
PRIMARY KEY (word_id)
);
<br />
<b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 6744308 bytes) in <b>/data/members/free/tripod/de/u/l/t/ultimagiggsy/htdocs/phpBB2/admin/admin_db_utilities.php</b> on line <b>851</b><br />
</pre></xmp></noscript>
<!-- SZM VERSION="1.3" -->
<script language="JavaScript" type="text/javascript">
<!--
var IVW="http://lycos.ivwbox.de/cgi-bin/ivw/CP/2B04APBA0000;";
document.write("<img src=\""+IVW+"?r="+escape(document.referrer)+"\" width=\"1\" height=\"1\" />");
// -->
</script>
<noscript>
<img src="http://lycos.ivwbox.de/cgi-bin/ivw/CP/2B04APBA0000;" width="1" height="1" /> </noscript>
<!-- /SZM -->
<!-- SZMFRABO VERSION="1.1" -->
<script language="JavaScript" type="text/javascript">
var szmvars="lycos//CP//2B04APBA0000";
</script>
<script src="http://lycos.ivwbox.de/2004/01/survey.js"
language="JavaScript" type="text/javascript"> </script>
<!-- /SZMFRABO -->
<script language="javascript" src="http://ads.tripod.lycos.de/ad/test_frame_size.js"></script>
<script language="javascript">
if (!AD_clientWindowSize()) {
document.write("<NOSC"+"RIPT>");
}
</script>
<script type="text/javascript">
function setCookie(name, value, expires, path, domain, secure) {
var curCookie = name + "=" + escape(value) +
((expires) ? "; expires=" + expires.toGMTString() : "") +
((path) ? "; path=" + path : "") +
((domain) ? "; domain=" + domain : "") +
((secure) ? "; secure" : "");
document.cookie = curCookie;
}
var ad_url = "http://ads.tripod.lycos.de/ad/google/frame.php?_url="+escape(self.location)+"&gg_bg=&gg_template=&mkw=&cat=noref";
var ref=window.document.referrer;
if(parent.LycosAdFrame) {
if(parent.memberPage && parent.memberPage.document.title ) {
parent.document.title=parent.memberPage.document.title;
}
if(parent.LycosAdFrame && parent.LycosAdFrame.location && (ref != "" && (ref+"?" != window.location) && (ref.substr(ref.length-1,1) != "/")) ) {
parent.LycosAdFrame.location.replace(ad_url);
}
setCookie("adFrameForcePHP",0,0," ");
parent.document.body.cols = "*,140";
}
else if(top.LycosAdFrame && top.LycosAdFrame.location) {
if ((ref != "" && (ref+"?" != top.window.location) && (ref.substr(ref.length-1,1) != "?"))) {
top.LycosAdFrame.location.replace(ad_url);
}
setCookie("adFrameForcePHP",0,0," ");
top.document.body.cols = "*,140";
}
else {
if (!window.opener) {
setCookie("adFrameForcePHP",1,0," ");
}
else {
setCookie("adFrameForcePHP",0,0," ");
}
}
if (window.top.location.href.indexOf("http://mitglied.lycos.de")!=-1) {
ad_frame = 1 ;
window.top.document.body.cols="*,140" ;
}
function resizeGoogleAdFrame() {
window.top.document.body.cols = "*,140";
}
if (ad_frame == 1 && AD_clientWindowSize()) {
setInterval("resizeGoogleAdFrame()", 30);
}
</script>
<script type="text/javascript" src="http://ads.tripod.lycos.de/ad/ad.php?cat=noref&mkw=&CC=de&ord=4071d2e5&adpref="></script>
Gibt es da eine möglichkeit die daten zu retten?
Hab nämlich irrtümlicher weise fast alle posts per pruning gelöscht
Backupgröße ist original ca. 6mb groß und kann hier besichtigt werden:
http://mitglied.lycos.de/giggsy/phpbb_db_backup.sql
Schon mal vielen Dank für eure hilfe!
mfg
Christian
