Re: Forum mittels Backupdatei wiederherstellen
Verfasst: 12.06.2009 00:35
Wir reden von einem phpbb2 Forum
Mh und wie erstell ich die Tabelle neu ?
Mh und wie erstell ich die Tabelle neu ?
Führe diesen SQL-Befehl in deinem Datenbank-Tool (z.b. phpmyadmin oder Mysqldumper) aus.Mh und wie erstell ich die Tabelle neu ?
Code: Alles auswählen
DROP TABLE IF EXISTS `phpbb_config`;
CREATE TABLE `phpbb_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Daten für Tabelle `phpbb_config`
--
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('config_id', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('board_disable', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('sitename', 'deine-domain.de');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('site_desc', 'Ein _kurzer_ Text, der Dein Forum beschreibt');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cookie_path', '/');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cookie_domain', '');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('session_length', '3600');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_html', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_sig', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_avatar_local', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_avatar_remote', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_avatar_upload', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('enable_confirm', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_autologin', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_autologin_time', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('override_user_style', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('posts_per_page', '15');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('topics_per_page', '50');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('hot_threshold', '25');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_poll_options', '10');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_sig_chars', '255');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_inbox_privmsgs', '50');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_sentbox_privmsgs', '25');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_savebox_privmsgs', '50');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('board_email_sig', 'Danke, das Forum-Team');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('board_email', 'admin@meinedomain.de');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('smtp_delivery', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('smtp_host', '');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('smtp_username', '');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('smtp_password', '');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('sendmail_fix', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('require_activation', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('flood_interval', '15');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('search_flood_interval', '15');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('search_min_chars', '3');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('max_login_attempts', '5');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('login_reset_time', '30');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('board_email_form', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('avatar_filesize', '6144');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('smilies_path', 'images/smiles');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('default_style', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('default_dateformat', 'd.m.Y, H:i');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('board_timezone', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('prune_enable', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('gzip_compress', '0');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('coppa_mail', '');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('record_online_users', '1');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('record_online_date', '1164409095');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('server_name', 'www.meinedomain.de');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('server_port', '80');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('script_path', '/phpBB2/');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('version', '.0.23');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('rand_seed', '3b1e610d3657eb9edb1b28408bdba83c');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('board_startdate', '1164408817');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('default_lang', 'german');Du kannst allerdings nach dem Anlegen der Tabelle auch den phpBB Board-Doktor für die Überprüfung der wichtigsten Einstellungen verwenden.
Edit: Was mir gerade noch einfällt - Wenn du ein phpBB2 Forum installiert hast und dein Backup mit dem Mysqldumper eingespielt hast - die Tabellen im Backup aber ein anderes Präfix haben als in deiner config.php steht, dann erhätlst du auch diese Meldung.
Also schau mal nach in der Datenbank, welches Präfix (Standard ist phpbb_ - also musst du schauen ob noch andere Tabellen mit anderem Präfix vorhanden sind) die Tabellen haben und passe deine Datei config.php entsprechend an (Also $table_prefix = 'phpbb_'; ändern)
Grüße: Mahony
