phpBB.nl

Adres van je forum: http://www.arnhemseluitjes.net/phpBB2/i ... d76f696e06
Event. modificaties op je forum:geen modificaties
Wanneer ontstond het probleem?database per ongeluk gewist :
Heb je onlangs iets veranderd aan je forum?nee
Wat is het probleem?

De vorige versie van het forum weet ik niet. De database was ongeveer drie en een half jaar oud. Tijdens werkzaamheden aan een andere database heb ik per ongeluk de database van het forum gewist.
Ik heb via elefante scripts bij mijn host een nieuw forum geInstalleerd: phpBB 2.0.22. De bestanden van het oude forum zijn er niet meer.
Helaas heb ik geen recente backup van de database. Dus ik probeer een backup van 11-11-2007 te installeren.

Ik heb het zonder succes geprobeerd via:
php myadmin - mysql - import. Resultaat :"geen querie"
het administratiepaneel van het forum

config.php is:
<?php
// phpBB 2.x auto-generated config file
// Do not change anything in this file!
$dbms = 'mysql4';

$dbhost = 'mysql1.100ws.com';
$dbname = 'corfro_luitjes';
$dbuser = 'corfro_luitjes';
$dbpasswd = '*********';
$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>
De eerste vijftig regels van database zijn:

Code: Selecteer alles

#
# phpBB Backup Script
# Dump of tables for corfro_luitjes
#
# DATE : 11-11-2007 17:03:45 GMT
#
#
# TABLE: phpbb_auth_access
#
DROP TABLE IF EXISTS phpbb_auth_access;
CREATE TABLE phpbb_auth_access(
   group_id mediumint(8) NOT NULL,
   forum_id smallint(5) unsigned NOT NULL,
   auth_view tinyint(1) NOT NULL,
   auth_read tinyint(1) NOT NULL,
   auth_post tinyint(1) NOT NULL,
   auth_reply tinyint(1) NOT NULL,
   auth_edit tinyint(1) NOT NULL,
   auth_delete tinyint(1) NOT NULL,
   auth_sticky tinyint(1) NOT NULL,
   auth_announce tinyint(1) NOT NULL,
   auth_vote tinyint(1) NOT NULL,
   auth_pollcreate tinyint(1) NOT NULL,
   auth_attachments tinyint(1) NOT NULL,
   auth_mod tinyint(1) NOT NULL, 
   KEY group_id (group_id), 
   KEY forum_id (forum_id)
);

#
# Table Data for phpbb_auth_access
#

INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('3', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('3', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
#
# TABLE: phpbb_banlist
#
DROP TABLE IF EXISTS phpbb_banlist;
CREATE TABLE phpbb_banlist(
   ban_id mediumint(8) unsigned NOT NULL auto_increment,
   ban_userid mediumint(8) NOT NULL,
   ban_ip varchar(8) NOT NULL,
   ban_email varchar(255), 
   PRIMARY KEY (ban_id), 
   KEY ban_ip_user_id (ban_ip, ban_userid)
);

#
# Table Data for phpbb_banlist
#

De laatste vijftig regels van de database zijn:

Code: Selecteer alles

INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('7', '-1', '51cd4eb0');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('4', '-1', '51cd4eb0');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '-1', '5450ec1a');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('5', '-1', 'd54bb682');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '-1', '51cd4eb0');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '-1', 'd48e2165');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '-1', '546b1557');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '-1', 'c26dc399');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '2', '52d70b46');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('5', '-1', '546b1557');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('6', '3', '52d70b46');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('7', '2', '52d70b46');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('7', '-1', 'd55d2087');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('7', '-1', '541b237a');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '58', '507f0a7a');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '8', 'd995d4e9');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '-1', '3ec2c1c9');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '3', '52d70b46');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '-1', '5655b92e');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '-1', '546b1557');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '-1', 'c26dc399');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('10', '-1', '541b202d');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('13', '58', '507f0a7a');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('13', '70', '3e8308e3');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('12', '23', '5353ba32');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('12', '3', '52d70b46');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('12', '63', '51ce19a1');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('12', '65', '507fe41b');
INSERT INTO phpbb_vote_voters (vote_id, vote_user_id, vote_user_ip) VALUES('12', '45', '54564894');
#
# 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)
);
#
# TABLE: phpbb_confirm
#
DROP TABLE IF EXISTS phpbb_confirm;
CREATE TABLE phpbb_confirm(
   confirm_id char(32) NOT NULL,
   session_id char(32) NOT NULL,
   code char(6) NOT NULL, 
   PRIMARY KEY (session_id, confirm_id)
);

Probleem is waarschijnlijk dat de database 10 mb is.
Ik heb ergens gelezen dat bigdump een mogelijkheid is.
Dit heb ik inmiddels geprobeerd.
Bigdump werkt inderdaad maar geeft de volgende fourmelding:
"Error at the line 16215: INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES bigdump"
Heeft iemand een idee wat dit betekent en hoe je het kunt oplossen?

Frank

phpBB.nl

database per ongeluk gewist

database per ongeluk gewist