phpMyAdmin und MySQLDumper?
lima-city → Forum → Programmiersprachen → PHP, MySQL & .htaccess
code
datei
datenbank
datum
forum
hilfe
http
importieren
impressum
last
not
null
problem
server
set
syntax
tabelle
text
url
versuchen
-
Da ich mich leider mit SQL sowie der der Oberfläschen für die verwaltung von SQL (phpMyAdmin und MySQLDumper) wenig auskenne, könnte ich ein wenig Hilfe gebrauchen.
Es geht um folgendes....
Habe versucht mit phpMyAdmin eine Datenbank hier von Lima-City zu Exportieren und diese dann in eine leere auch hier bei Lima-City, wieder zu importieren.
Leider macht er das nicht egal welche Option ich wähle oder weg lasse.
Egentlich wird es dadurch nur schlimmer,
was bedeuten soll das er noch weniger schafft zu importieren bevor er stoppt.
Ich bekomme folgende Meldung:
Fehler SQL-Befehl: -- -- Daten für Tabelle `phpbb_banlist` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_bbcodes` -- CREATE TABLE IF NOT EXISTS `phpbb_bbcodes` ( `bbcode_id` tinyint( 3 ) NOT NULL default '0', `bbcode_tag` varchar( 16 ) COLLATE utf8_bin NOT NULL default '', `bbcode_helpline` varchar( 255 ) COLLATE utf8_bin NOT NULL default '', `display_on_posting` tinyint( 1 ) unsigned NOT NULL default '0', `bbcode_match` text COLLATE utf8_bin NOT NULL , `bbcode_tpl` mediumtext COLLATE utf8_bin NOT NULL , `first_pass_match` mediumtext COLLATE utf8_bin NOT NULL , `first_pass_replace` mediumtext COLLATE utf8_bin NOT NULL , `second_pass_match` mediumtext COLLATE utf8_bin NOT NULL , `second_pass_replace` mediumtext COLLATE utf8_bin NOT NULL , PRIMARY KEY ( `bbcode_id` ) , KEY `display_on_post` ( `display_on_posting` ) ) ENGINE = MYISAM DEFAULTCHARSE MySQL meldet: Dokumentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARSE' at line 22
Wenn ich das richtig verstehe sagt er mir das der Zeichensatz nicht stimmt.
Oder liege ich da falsch?
Das lustige ist das der Quell-Server der selbe wie der Ziel-Server ist.
Wenn ich logisch darüber nachdenke sollte er damit eigentlich keine Probleme haben.
Zum 2. seltsamen Problem.....
Da das fehl geschlagen ist haben ich dann mein Glück mit MySQLDumper versuchen wollen,
was aber nicht geht weil er mir ausgerechnet die Datenbank die ich sichern will nicht anzeigt.
Was bedeuten soll das die Datenbank wohl für den MySQLDumper nicht vorhanden ist.
Die existiert aber sehr wohl.
Langsam verzweifel ich, möchte doch nur ein BackUp der Datenbank machen. :(
Für sämtliche Rechschreibfehler entschuldige ich mich, bin die ganze nacht auf den beinen.
Gruß Markus -
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!
lima-city: Gratis werbefreier Webspace für deine eigene Homepage
-
Versuch dich doch mal mit dem kostenlosen Tool Navicat light
Damit kann man sehr bequem in einer Benutzeroberfläche vom PC aus die Tabellen mit Struktur und/oder Daten hin und her transferieren. -
OK, werde das mal versuchen.
Aber kann mir auch jemand erklären warum das mit den "standart" Apps nicht funzt?
Bzw. warum MySQLDumper die DB nicht sieht?
Denn seltsam ist es schon. -
Kannst du vielleicht den Inhalt der Datei mal posten, insofern nicht irgendwas Geheimes drinsteht?
-
Ne ist nix geheimes!
-- phpMyAdmin SQL Dump -- version 3.2.2 -- http://www.phpmyadmin.net -- -- Host: mysql.lima-city.de -- Erstellungszeit: 01. Dezember 2009 um 12:26 -- Server Version: 5.0.32 -- PHP-Version: 5.2.11 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Datenbank: `db_157911_4` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `magic_config` -- CREATE TABLE IF NOT EXISTS `magic_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` blob NOT NULL, `is_dynamic` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`config_name`), KEY `is_dynamic` (`is_dynamic`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten für Tabelle `magic_config` -- INSERT INTO `magic_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('forum_news', 0x30, 0), ('max_forum_news', 0x35, 0), ('last_members', 0x35, 0), ('last_update', 0x31332e4a756c2e323030382030333a3435, 1), ('last_visitors', 0x35, 0), ('newsticker_deep', 0x35, 0), ('next_days_birthdays', 0x33, 0), ('owner_description', 0x496e746572657373656e67656d65696e736368616674202f2056657265696e206f686e6520476577696e6e61627369636874, 0), ('owner_email', 0x6b72696e67732e6d61726b757340676f6f676c656d61696c2e636f6d, 0), ('owner_first_name', 0x4d61726b7573, 0), ('owner_name', 0x4b72696e6773, 0), ('owner_phone', 0x30323431202f, 0), ('owner_pm', '', 0), ('owner_street', 0x416c742d48616172656e65722053747261c39f65, 0), ('owner_username', 0x41646d696e, 0), ('owner_zip', 0x41616368656e, 0), ('poll', '', 0), ('recent_topics', 0x3130, 0), ('top_poster', 0x35, 0), ('version', 0x312e302e524336, 0), ('welcome', 0x3c68746d6c3e0a3c686561643e0a3c6d65746120687474702d65717569763d22436f6e74656e742d547970652220636f6e74656e743d22746578742f68746d6c3b20636861727365743d69736f2d383835392d31223e0a3c7374796c6520747970653d22746578742f637373223e0a3c212d2d0a2e5374696c38207b0a09666f6e742d73697a653a20313670783b0a09636f6c6f723a20233030303036363b0a7d0a2e5374696c3130207b0a09666f6e742d73697a653a20313870783b0a09636f6c6f723a20233030303036363b0a09666f6e742d7765696768743a20626f6c643b0a7d0a2d2d3e0a3c2f7374796c653e0a3c2f686561643e0a0a3c626f64793e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c3130223e57696c6c6b6f6d6d656e20626569204d6964676172647320457262656e213c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e5769722073696e642065696e6520696e746572657373656e2047656d65696e7363686166742c206469652073696368207a756d205a69656c2067656d61636874206861742c203c62723e0a2020646965204b756c74757220756e6420576572746520646572204765726d616e69736368656e2053742661756d6c3b6d6d652c204b656c74656e20756e642057696b696e676572207a753c62723e0a2020776172656e20756e6420776965646572206175666572737465686e207a75206c617373656e2e3c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e5769722073696e64206465722041756666617373756e672c2064617320696e2064657220686575746967656e207363686e656c6c65626967656e205a6569742c203c62723e0a2020696e646572206a65646572206e7572206e6f636820662675756d6c3b722073696368206c6562742c20696e6465722046616d696c69656e206b65696e656e205a7573616d6d656e68616c74206d656872206b656e6e656e2c203c62723e0a202064696520476573656c6c73636861667420696d6d6572206d656872207665726f687420756e6420576572746520756e6420747567656e64656e20696e207765697465204665726e65206765722675756d6c3b636b742073696e642c203c62723e0a20206573206e6f6368206e696520736f206e266f756d6c3b746967207761722c207369636820776965646572206175662064696520616c74656e2057656765207a7520626573696e6e656e2e3c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e576972206d266f756d6c3b636874656e2076657268696e6465726e2064617320616c6c20646965204765726d616e69736368656e2053742661756d6c3b6d6d652073616d742069687265723c62723e0a2020476c617562656e73766f727374656c6c756e6720756e642057656c74616e7363686175756e67206e6f6368206d65687220696e2056657267657373656e68656974206765726174656e2e203c62723e0a202041756368206d69742064657220566f727374656c6c756e672c206461732073696520756e7a6976696c6973696572746520426172626172656e20776172656e20776f6c6c656e2077697220617566722661756d6c3b756d656e2e3c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e3c62723e0a202057697220776f6c6c656e20657563682062657269636874656e20766f6e206675726368746c6f73656e204b7269656765726e2c206469652064656e2052266f756d6c3b6d65726e2064617320462675756d6c3b72636874656e206c65687274656e2e3c62723e0a2020566f6e206d75746967656e2046726175656e20756e642067726f26737a6c69673b656e205363686c61636874656e2c206b6c65696e656e20566965687a2675756d6c3b63687465726e2c20446963687465726e20756e642047656c65687274656e2e3c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e57697220776f6c6c656e20646965204d656e736368656e20646172616e206572696e6e65726e2c206461732065732061756368204b756c747572656e20696e3c62723e0a2020766f72204368726973746c6963686572205a65697420676162656e2c20646965204a61687268756e6465727465206c616e672042657374616e642068617474656e2e3c62723e0a20204d697420696872656e20656967656e656e2047266f756d6c3b747465726e2c205765697368656974656e20756e642048656c64656e2e3c62723e0a2020496e2064657220666173742033303030204a6168726520616c74656e2047657363686963687465206469657365722056266f756d6c3b6c6b65722073696e6420756e7363682661756d6c3b747a626172653c62723e0a20204175667a656963686e756e67656e2c2052656c696b746520756e64205275696e656e20756e7769656465726272696e676c696368207a65727374266f756d6c3b727420776f7264656e2e203c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e3c62723e0a2020446f7274206d266f756d6c3b636874656e2077697220616e7365747a74656e20756e6420646173207a7573616d6d656e676574726167656e652057697373656e3c62723e0a2020617573204e616368666f72736368756e67656e2c2052656b6f6e737472756b74696f6e656e20756e6420617263682661756d6c3b6f6c6f6769736368656e2066756e64656e3c62723e0a20207a7573616d6d656e74726167656e20756e642061756620756e736572657220536569746520662675756d6c3b7220696e746572657373696572746520626572656974207374656c6c656e2e3c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e5769722073696e64206b65696e652047727570706520766f6e20536f6e6465726c696e67656e2c2064696520736963682064696520456973656e7a656974207a75722675756d6c3b636b20772675756d6c3b6e736368656e3c62723e0a20207765696c207369652064656e6b656e2064616d616c732073656920616c6c657320736368266f756d6c3b6e6572206765776573656e2e205769722073696e6420756e732064657373656e206265777526737a6c69673b7420646173206469653c62723e0a202068657574696765205a65697420736963686572206968726520566f727a2675756d6c3b6765206861742e3c2f703e0a3c7020616c69676e3d2263656e7465722220636c6173733d225374696c38223e44656e6e6f63682076657273756368656e2077697220646173204c6562656e20646572204765726d616e69736368656e2056266f756d6c3b6c6b6572206d266f756d6c3b676c69636873743c62723e0a202061757468656e746973636820617566204d697474656c616c746572204d2661756d6c3b726b74656e20756e64202661756d6c3b686e6c696368656e20566572616e7374616c74756e67656e206461727a75207374656c6c656e2e3c62723e0a202053656920657320646173204c616765726c6562656e2c2048616e647765726b206f64657220646965204b72696567736b756e73742e3c62723e0a2020576972206c6562656e206e6163682064656e20616c74656e2047657365747a74656e20736f7765697420657320756e64206d266f756d6c3b676c696368206973742c2068616c74656e20616e2064656e20616c74656e3c62723e0a202053697474656e20756e6420476562722661756d6c3b756368656e206665737420756e64207a656967656e206175662c2077617320576f72746520776965204c6f79616c69742661756d6c3b742c20456872652c2046616d696c696520756e64203c62723e0a202047617374667265756e6473636861667420696e20696872657220556d7365747a74756e6720626564657574656e2e3c2f703e0a3c2f626f64793e0a3c2f68746d6c3e, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `magic_modules` -- CREATE TABLE IF NOT EXISTS `magic_modules` ( `module_id` mediumint(8) unsigned NOT NULL auto_increment, `module_description` varchar(255) NOT NULL default '', `module_type` varchar(6) NOT NULL default 'Extern', `module_enabled` tinyint(1) NOT NULL default '0', `module_display_portal` tinyint(1) NOT NULL default '0', `module_display_index` tinyint(1) NOT NULL default '0', `module_rows` varchar(6) NOT NULL default '', `module_cols` tinyint(2) NOT NULL default '0', `module_path` varchar(255) NOT NULL default '', `module_template_name` varchar(255) NOT NULL default '', `module_script_name` varchar(255) NOT NULL default '', `module_icon` varchar(255) NOT NULL default '', `module_lang` varchar(255) NOT NULL default '', PRIMARY KEY (`module_id`), KEY `module_enabled` (`module_enabled`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ; -- -- Daten für Tabelle `magic_modules` -- INSERT INTO `magic_modules` (`module_id`, `module_description`, `module_type`, `module_enabled`, `module_display_portal`, `module_display_index`, `module_rows`, `module_cols`, `module_path`, `module_template_name`, `module_script_name`, `module_icon`, `module_lang`) VALUES (1, 'Login', 'Intern', 1, 1, 0, 'right', 3, '', 'magic_login_body', '', '', ''), (2, 'Main Menu', 'Extern', 1, 1, 1, 'left', 1, 'magic/', 'magic_main_menu_body', 'magic_main_menu', '', ''), (3, 'User Menu', 'Extern', 1, 1, 1, 'left', 2, 'magic/', 'magic_user_menu_body', 'magic_user_menu', '', ''), (4, 'Modules Menu', 'Extern', 1, 1, 1, 'left', 2, 'magic/', 'magic_modules_menu_body', 'magic_modules_menu', '', ''), (5, 'Impressum', 'Link', 1, 0, 0, '', 0, 'impressum/', '', 'impressum', 'icon-minilink', ''), (6, 'Gallery', 'Link', 1, 0, 0, '', 0, 'gallery/', '', 'index', 'icon-gallery', 'mods/gallery'), (7, 'Calendar', 'Link', 1, 0, 0, '', 0, 'calendar/', '', 'calendar', 'icon-pages', 'mods/calendar'), (8, 'Welcome', 'Intern', 1, 1, 0, 'center', 1, '', 'magic_welcome_body', '', '', ''), (9, 'Statistic', 'Intern', 1, 1, 0, 'right', 4, '', 'magic_statistic_body', '', '', ''), (10, 'Who is Online', 'Intern', 1, 1, 1, 'left', 3, '', 'magic_who_is_online_body', '', '', ''), (11, 'User Welcome', 'Extern', 1, 1, 0, 'right', 1, 'magic/', 'magic_user_welcome_body', 'magic_user_welcome', '', ''), (12, 'Poll', 'Extern', 1, 1, 0, 'center', 4, 'magic/', 'magic_poll_body', 'magic_poll', '', ''), (13, 'Announcements', 'Extern', 1, 1, 0, 'center', 2, 'magic/', 'magic_announcements_body', 'magic_announcements', '', ''), (14, 'Friends', 'Extern', 1, 1, 1, 'left', 6, 'magic/', 'magic_friends', 'magic_friends', '', ''), (16, 'mini calendar', 'Extern', 1, 1, 0, 'right', 6, 'mini_cal/', 'mini_cal_body', 'mini_cal', '', ''), (17, 'mini calendar', 'Extern', 1, 0, 1, 'left', 7, 'mini_cal/', 'mini_cal_body', 'mini_cal', '', ''), (18, 'Portal_Birthday', 'Extern', 1, 0, 1, 'left', 5, 'magic/', 'magic_birthday_body', 'magic_birthday', '', ''), (19, 'Last Visits', 'Extern', 1, 1, 0, 'right', 7, 'magic/', 'magic_last_visit_body', 'magic_last_visit', '', ''), (20, 'Shoutbox', 'Extern', 1, 0, 1, 'left', 4, 'shoutbox/', 'magic_shoutbox_body', 'magic_shoutbox', '', ''), (21, 'Newsticker', 'Extern', 0, 1, 0, 'left', 8, 'rss-feed/', 'magic_newsticker_body', 'rss-feed', '', ''), (22, 'Clock', 'Intern', 1, 1, 0, 'right', 2, '', 'magic_clock_body', '', '', ''), (23, 'Banner', 'Intern', 0, 1, 0, 'bottom', 1, '', 'magic_banner_body', '', '', ''), (24, 'Weather', 'Extern', 1, 1, 0, 'left', 7, 'magic/', 'magic_weather_body', 'magic_weather', '', ''), (25, 'Statistic', 'Intern', 1, 0, 1, 'left', 4, '', 'magic_statistic_body', '', '', ''), (26, 'Recent Topics', 'Extern', 1, 1, 0, 'center', 3, 'magic/', 'magic_recent_topics_body', 'magic_recent_topics', '', ''), (27, 'Breadcrumbs', 'Intern', 0, 0, 1, 'top', 0, '', 'breadcrumbs_body', '', '', ''), (28, 'Links', 'Intern', 1, 1, 0, 'center', 7, '', 'magic_link_body', '', '', ''), (29, 'Portal_Birthday', 'Extern', 1, 1, 0, 'right', 3, 'magic/', 'magic_birthday_body', 'magic_birthday', '', ''), (30, 'Auth DST Switch', 'Extern', 1, 0, 0, '', 0, 'magic/', '', 'magic_auth_dst_switch', '', ''), (31, 'Last Members', 'Extern', 1, 1, 0, 'left', 11, 'magic/', 'magic_last_members_body', 'magic_last_members', '', ''), (32, 'Top Poster', 'Extern', 1, 1, 0, 'left', 10, 'magic/', 'magic_top_poster_body', 'magic_top_poster', '', ''), (33, 'Forum News', 'Extern', 1, 1, 0, 'center', 2, 'magic/', 'magic_news_body', 'magic_news', '', ''), (34, 'Recent Pictures', 'Extern', 1, 1, 1, 'left', 4, 'magic/', 'magic_recent_pictures_body', 'magic_recent_pictures', '', ''), (35, 'Random Pictures', 'Extern', 1, 1, 0, 'center', 6, 'magic/', 'magic_random_pictures_body', 'magic_random_pictures', '', ''), (36, 'GeoMap', 'Link', 1, 0, 0, '', 3, 'magic/', '', 'geomap', 'icon-geomap', 'mods/geomap'), (37, 'GeoMap', 'Link', 1, 0, 0, '', 3, 'magic/', '', 'geomap', 'icon-geomap', 'mods/geomap'), (38, 'magic_wwh', 'Extern', 1, 1, 1, 'left', 3, 'magic/', 'magic_who_was_here_body', 'magic_wwh', '', ''); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_acl_groups` -- CREATE TABLE IF NOT EXISTS `phpbb_acl_groups` ( `group_id` mediumint(8) unsigned NOT NULL default '0', `forum_id` mediumint(8) unsigned NOT NULL default '0', `auth_option_id` mediumint(8) unsigned NOT NULL default '0', `auth_role_id` mediumint(8) unsigned NOT NULL default '0', `auth_setting` tinyint(2) NOT NULL default '0', KEY `group_id` (`group_id`), KEY `auth_opt_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Daten für Tabelle `phpbb_acl_groups` -- INSERT INTO `phpbb_acl_groups` (`group_id`, `forum_id`, `auth_option_id`, `auth_role_id`, `auth_setting`) VALUES (1, 0, 85, 0, 1), (1, 0, 93, 0, 1), (1, 0, 111, 0, 1), (5, 0, 0, 5, 0), (5, 0, 0, 1, 0), (2, 0, 0, 6, 0), (3, 0, 0, 6, 0), (4, 0, 0, 5, 0), (4, 0, 0, 10, 0), (1, 1, 0, 17, 0), (2, 1, 0, 22, 0), (3, 1, 0, 17, 0), (6, 1, 0, 17, 0), (1, 2, 0, 17, 0), (2, 2, 0, 22, 0), (3, 2, 0, 15, 0), (4, 2, 0, 14, 0), (5, 2, 0, 14, 0), (5, 2, 0, 10, 0), (6, 2, 0, 19, 0), (7, 1, 0, 21, 0), (7, 2, 0, 21, 0), (7, 4, 0, 14, 0), (7, 5, 0, 14, 0), (7, 3, 0, 16, 0), (7, 6, 0, 16, 0), (7, 7, 0, 22, 0), (7, 8, 0, 22, 0), (7, 1, 0, 12, 0), (7, 2, 0, 12, 0), (7, 4, 0, 12, 0), (7, 5, 0, 12, 0), (2, 4, 0, 17, 0), (2, 5, 0, 17, 0), (2, 3, 0, 16, 0), (2, 6, 0, 16, 0), (2, 7, 0, 16, 0), (2, 8, 0, 16, 0), (1, 9, 0, 17, 0), (2, 9, 0, 22, 0), (3, 9, 0, 17, 0), (6, 9, 0, 17, 0), (7, 9, 0, 21, 0), (7, 9, 0, 12, 0), (5, 1, 0, 14, 0), (5, 4, 0, 14, 0), (5, 5, 0, 14, 0), (5, 3, 0, 14, 0), (5, 6, 0, 14, 0), (5, 7, 0, 14, 0), (5, 8, 0, 14, 0), (5, 9, 0, 14, 0), (9, 1, 0, 21, 0), (9, 2, 0, 22, 0), (9, 4, 0, 21, 0), (9, 5, 0, 21, 0), (9, 3, 0, 22, 0), (9, 6, 0, 22, 0), (9, 9, 0, 22, 0), (4, 1, 0, 14, 0), (4, 4, 0, 14, 0), (4, 5, 0, 14, 0), (4, 3, 0, 14, 0), (4, 6, 0, 14, 0), (4, 7, 0, 14, 0), (4, 8, 0, 14, 0), (4, 9, 0, 14, 0), (4, 1, 0, 10, 0), (4, 2, 0, 10, 0), (4, 4, 0, 11, 0), (4, 5, 0, 11, 0), (4, 3, 0, 12, 0), (4, 6, 0, 12, 0), (4, 7, 0, 12, 0), (4, 8, 0, 12, 0), (4, 9, 0, 12, 0), (1, 10, 0, 17, 0), (2, 10, 0, 22, 0), (3, 10, 0, 17, 0), (6, 10, 0, 17, 0), (7, 10, 0, 21, 0), (7, 10, 0, 12, 0), (5, 10, 0, 14, 0), (9, 10, 0, 21, 0), (4, 10, 0, 14, 0), (4, 10, 0, 10, 0), (1, 11, 0, 17, 0), (2, 11, 0, 22, 0), (3, 11, 0, 17, 0), (6, 11, 0, 17, 0), (7, 11, 0, 21, 0), (7, 11, 0, 12, 0), (5, 11, 0, 14, 0), (9, 11, 0, 21, 0), (4, 11, 0, 14, 0), (4, 11, 0, 10, 0), (1, 12, 0, 17, 0), (2, 12, 0, 22, 0), (3, 12, 0, 17, 0), (6, 12, 0, 17, 0), (7, 12, 0, 21, 0), (7, 12, 0, 12, 0), (5, 12, 0, 14, 0), (9, 12, 0, 21, 0), (4, 12, 0, 14, 0), (4, 12, 0, 10, 0), (1, 13, 0, 17, 0), (2, 13, 0, 22, 0), (3, 13, 0, 17, 0), (6, 13, 0, 17, 0), (7, 13, 0, 21, 0), (7, 13, 0, 12, 0), (5, 13, 0, 14, 0), (9, 13, 0, 21, 0), (4, 13, 0, 14, 0), (4, 13, 0, 10, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_acl_options` -- CREATE TABLE IF NOT EXISTS `phpbb_acl_options` ( `auth_option_id` mediumint(8) unsigned NOT NULL auto_increment, `auth_option` varchar(50) collate utf8_bin NOT NULL default '', `is_global` tinyint(1) unsigned NOT NULL default '0', `is_local` tinyint(1) unsigned NOT NULL default '0', `founder_only` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`auth_option_id`), KEY `auth_option` (`auth_option`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=125 ; -- -- Daten für Tabelle `phpbb_acl_options` -- INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (1, 'f_', 0, 1, 0), (2, 'f_announce', 0, 1, 0), (3, 'f_attach', 0, 1, 0), (4, 'f_bbcode', 0, 1, 0), (5, 'f_bump', 0, 1, 0), (6, 'f_delete', 0, 1, 0), (7, 'f_download', 0, 1, 0), (8, 'f_edit', 0, 1, 0), (9, 'f_email', 0, 1, 0), (10, 'f_flash', 0, 1, 0), (11, 'f_icons', 0, 1, 0), (12, 'f_ignoreflood', 0, 1, 0), (13, 'f_img', 0, 1, 0), (14, 'f_list', 0, 1, 0), (15, 'f_noapprove', 0, 1, 0), (16, 'f_poll', 0, 1, 0), (17, 'f_post', 0, 1, 0), (18, 'f_postcount', 0, 1, 0), (19, 'f_print', 0, 1, 0), (20, 'f_read', 0, 1, 0), (21, 'f_reply', 0, 1, 0), (22, 'f_report', 0, 1, 0), (23, 'f_search', 0, 1, 0), (24, 'f_sigs', 0, 1, 0), (25, 'f_smilies', 0, 1, 0), (26, 'f_sticky', 0, 1, 0), (27, 'f_subscribe', 0, 1, 0), (28, 'f_user_lock', 0, 1, 0), (29, 'f_vote', 0, 1, 0), (30, 'f_votechg', 0, 1, 0), (31, 'm_', 1, 1, 0), (32, 'm_approve', 1, 1, 0), (33, 'm_chgposter', 1, 1, 0), (34, 'm_delete', 1, 1, 0), (35, 'm_edit', 1, 1, 0), (36, 'm_info', 1, 1, 0), (37, 'm_lock', 1, 1, 0), (38, 'm_merge', 1, 1, 0), (39, 'm_move', 1, 1, 0), (40, 'm_report', 1, 1, 0), (41, 'm_split', 1, 1, 0), (42, 'm_ban', 1, 0, 0), (43, 'm_warn', 1, 0, 0), (44, 'a_', 1, 0, 0), (45, 'a_aauth', 1, 0, 0), (46, 'a_attach', 1, 0, 0), (47, 'a_authgroups', 1, 0, 0), (48, 'a_authusers', 1, 0, 0), (49, 'a_backup', 1, 0, 0), (50, 'a_ban', 1, 0, 0), (51, 'a_bbcode', 1, 0, 0), (52, 'a_board', 1, 0, 0), (53, 'a_bots', 1, 0, 0), (54, 'a_clearlogs', 1, 0, 0), (55, 'a_email', 1, 0, 0), (56, 'a_fauth', 1, 0, 0), (57, 'a_forum', 1, 0, 0), (58, 'a_forumadd', 1, 0, 0), (59, 'a_forumdel', 1, 0, 0), (60, 'a_group', 1, 0, 0), (61, 'a_groupadd', 1, 0, 0), (62, 'a_groupdel', 1, 0, 0), (63, 'a_icons', 1, 0, 0), (64, 'a_jabber', 1, 0, 0), (65, 'a_language', 1, 0, 0), (66, 'a_mauth', 1, 0, 0), (67, 'a_modules', 1, 0, 0), (68, 'a_names', 1, 0, 0), (69, 'a_phpinfo', 1, 0, 0), (70, 'a_profile', 1, 0, 0), (71, 'a_prune', 1, 0, 0), (72, 'a_ranks', 1, 0, 0), (73, 'a_reasons', 1, 0, 0), (74, 'a_roles', 1, 0, 0), (75, 'a_search', 1, 0, 0), (76, 'a_server', 1, 0, 0), (77, 'a_styles', 1, 0, 0), (78, 'a_switchperm', 1, 0, 0), (79, 'a_uauth', 1, 0, 0), (80, 'a_user', 1, 0, 0), (81, 'a_userdel', 1, 0, 0), (82, 'a_viewauth', 1, 0, 0), (83, 'a_viewlogs', 1, 0, 0), (84, 'a_words', 1, 0, 0), (85, 'u_', 1, 0, 0), (86, 'u_attach', 1, 0, 0), (87, 'u_chgavatar', 1, 0, 0), (88, 'u_chgcensors', 1, 0, 0), (89, 'u_chgemail', 1, 0, 0), (90, 'u_chggrp', 1, 0, 0), (91, 'u_chgname', 1, 0, 0), (92, 'u_chgpasswd', 1, 0, 0), (93, 'u_download', 1, 0, 0), (94, 'u_hideonline', 1, 0, 0), (95, 'u_ignoreflood', 1, 0, 0), (96, 'u_masspm', 1, 0, 0), (97, 'u_masspm_group', 1, 0, 0), (98, 'u_pm_attach', 1, 0, 0), (99, 'u_pm_bbcode', 1, 0, 0), (100, 'u_pm_delete', 1, 0, 0), (101, 'u_pm_download', 1, 0, 0), (102, 'u_pm_edit', 1, 0, 0), (103, 'u_pm_emailpm', 1, 0, 0), (104, 'u_pm_flash', 1, 0, 0), (105, 'u_pm_forward', 1, 0, 0), (106, 'u_pm_img', 1, 0, 0), (107, 'u_pm_printpm', 1, 0, 0), (108, 'u_pm_smilies', 1, 0, 0), (109, 'u_readpm', 1, 0, 0), (110, 'u_savedrafts', 1, 0, 0), (111, 'u_search', 1, 0, 0), (112, 'u_sendemail', 1, 0, 0), (113, 'u_sendim', 1, 0, 0), (114, 'u_sendpm', 1, 0, 0), (115, 'u_sig', 1, 0, 0), (116, 'u_viewonline', 1, 0, 0), (117, 'u_viewprofile', 1, 0, 0), (118, 'a_calendar', 1, 0, 0), (119, 'm_calendar_edit_other_users_events', 1, 0, 0), (120, 'm_calendar_delete_other_users_events', 1, 0, 0), (121, 'u_calendar_view_events', 1, 0, 0), (122, 'u_calendar_create_events', 1, 0, 0), (123, 'u_calendar_edit_events', 1, 0, 0), (124, 'u_calendar_delete_events', 1, 0, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_acl_roles` -- CREATE TABLE IF NOT EXISTS `phpbb_acl_roles` ( `role_id` mediumint(8) unsigned NOT NULL auto_increment, `role_name` varchar(255) collate utf8_bin NOT NULL default '', `role_description` text collate utf8_bin NOT NULL, `role_type` varchar(10) collate utf8_bin NOT NULL default '', `role_order` smallint(4) unsigned NOT NULL default '0', PRIMARY KEY (`role_id`), KEY `role_type` (`role_type`), KEY `role_order` (`role_order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=23 ; -- -- Daten für Tabelle `phpbb_acl_roles` -- INSERT INTO `phpbb_acl_roles` (`role_id`, `role_name`, `role_description`, `role_type`, `role_order`) VALUES (1, 'ROLE_ADMIN_STANDARD', 'ROLE_DESCRIPTION_ADMIN_STANDARD', 'a_', 1), (2, 'ROLE_ADMIN_FORUM', 'ROLE_DESCRIPTION_ADMIN_FORUM', 'a_', 3), (3, 'ROLE_ADMIN_USERGROUP', 'ROLE_DESCRIPTION_ADMIN_USERGROUP', 'a_', 4), (4, 'ROLE_ADMIN_FULL', 'ROLE_DESCRIPTION_ADMIN_FULL', 'a_', 2), (5, 'ROLE_USER_FULL', 'ROLE_DESCRIPTION_USER_FULL', 'u_', 3), (6, 'ROLE_USER_STANDARD', 'ROLE_DESCRIPTION_USER_STANDARD', 'u_', 1), (7, 'ROLE_USER_LIMITED', 'ROLE_DESCRIPTION_USER_LIMITED', 'u_', 2), (8, 'ROLE_USER_NOPM', 'ROLE_DESCRIPTION_USER_NOPM', 'u_', 4), (9, 'ROLE_USER_NOAVATAR', 'ROLE_DESCRIPTION_USER_NOAVATAR', 'u_', 5), (10, 'ROLE_MOD_FULL', 'ROLE_DESCRIPTION_MOD_FULL', 'm_', 3), (11, 'ROLE_MOD_STANDARD', 'ROLE_DESCRIPTION_MOD_STANDARD', 'm_', 1), (12, 'ROLE_MOD_SIMPLE', 'ROLE_DESCRIPTION_MOD_SIMPLE', 'm_', 2), (13, 'ROLE_MOD_QUEUE', 'ROLE_DESCRIPTION_MOD_QUEUE', 'm_', 4), (14, 'ROLE_FORUM_FULL', 'ROLE_DESCRIPTION_FORUM_FULL', 'f_', 7), (15, 'ROLE_FORUM_STANDARD', 'ROLE_DESCRIPTION_FORUM_STANDARD', 'f_', 5), (16, 'ROLE_FORUM_NOACCESS', 'ROLE_DESCRIPTION_FORUM_NOACCESS', 'f_', 1), (17, 'ROLE_FORUM_READONLY', 'ROLE_DESCRIPTION_FORUM_READONLY', 'f_', 2), (18, 'ROLE_FORUM_LIMITED', 'ROLE_DESCRIPTION_FORUM_LIMITED', 'f_', 3), (19, 'ROLE_FORUM_BOT', 'ROLE_DESCRIPTION_FORUM_BOT', 'f_', 9), (20, 'ROLE_FORUM_ONQUEUE', 'ROLE_DESCRIPTION_FORUM_ONQUEUE', 'f_', 8), (21, 'ROLE_FORUM_POLLS', 'ROLE_DESCRIPTION_FORUM_POLLS', 'f_', 6), (22, 'ROLE_FORUM_LIMITED_POLLS', 'ROLE_DESCRIPTION_FORUM_LIMITED_POLLS', 'f_', 4); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_acl_roles_data` -- CREATE TABLE IF NOT EXISTS `phpbb_acl_roles_data` ( `role_id` mediumint(8) unsigned NOT NULL default '0', `auth_option_id` mediumint(8) unsigned NOT NULL default '0', `auth_setting` tinyint(2) NOT NULL default '0', PRIMARY KEY (`role_id`,`auth_option_id`), KEY `ath_op_id` (`auth_option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Daten für Tabelle `phpbb_acl_roles_data` -- INSERT INTO `phpbb_acl_roles_data` (`role_id`, `auth_option_id`, `auth_setting`) VALUES (1, 44, 1), (1, 46, 1), (1, 47, 1), (1, 48, 1), (1, 50, 1), (1, 51, 1), (1, 52, 1), (1, 56, 1), (1, 57, 1), (1, 58, 1), (1, 59, 1), (1, 60, 1), (1, 61, 1), (1, 62, 1), (1, 63, 1), (1, 66, 1), (1, 68, 1), (1, 70, 1), (1, 71, 1), (1, 72, 1), (1, 73, 1), (1, 79, 1), (1, 80, 1), (1, 81, 1), (1, 82, 1), (1, 83, 1), (1, 84, 1), (2, 44, 1), (2, 47, 1), (2, 48, 1), (2, 56, 1), (2, 57, 1), (2, 58, 1), (2, 59, 1), (2, 66, 1), (2, 71, 1), (2, 79, 1), (2, 82, 1), (2, 83, 1), (3, 44, 1), (3, 47, 1), (3, 48, 1), (3, 50, 1), (3, 60, 1), (3, 61, 1), (3, 62, 1), (3, 72, 1), (3, 79, 1), (3, 80, 1), (3, 82, 1), (3, 83, 1), (4, 44, 1), (4, 45, 1), (4, 46, 1), (4, 47, 1), (4, 48, 1), (4, 49, 1), (4, 50, 1), (4, 51, 1), (4, 52, 1), (4, 53, 1), (4, 54, 1), (4, 55, 1), (4, 56, 1), (4, 57, 1), (4, 58, 1), (4, 59, 1), (4, 60, 1), (4, 61, 1), (4, 62, 1), (4, 63, 1), (4, 64, 1), (4, 65, 1), (4, 66, 1), (4, 67, 1), (4, 68, 1), (4, 69, 1), (4, 70, 1), (4, 71, 1), (4, 72, 1), (4, 73, 1), (4, 74, 1), (4, 75, 1), (4, 76, 1), (4, 77, 1), (4, 78, 1), (4, 79, 1), (4, 80, 1), (4, 81, 1), (4, 82, 1), (4, 83, 1), (4, 84, 1), (5, 85, 1), (5, 86, 1), (5, 87, 1), (5, 88, 1), (5, 89, 1), (5, 90, 1), (5, 91, 1), (5, 92, 1), (5, 93, 1), (5, 94, 1), (5, 95, 1), (5, 96, 1), (5, 97, 1), (5, 98, 1), (5, 99, 1), (5, 100, 1), (5, 101, 1), (5, 102, 1), (5, 103, 1), (5, 104, 1), (5, 105, 1), (5, 106, 1), (5, 107, 1), (5, 108, 1), (5, 109, 1), (5, 110, 1), (5, 111, 1), (5, 112, 1), (5, 113, 1), (5, 114, 1), (5, 115, 1), (5, 116, 1), (5, 117, 1), (6, 85, 1), (6, 86, 1), (6, 87, 1), (6, 88, 1), (6, 89, 1), (6, 92, 1), (6, 93, 1), (6, 94, 1), (6, 96, 1), (6, 97, 1), (6, 98, 1), (6, 99, 1), (6, 100, 1), (6, 101, 1), (6, 102, 1), (6, 103, 1), (6, 106, 1), (6, 107, 1), (6, 108, 1), (6, 109, 1), (6, 110, 1), (6, 111, 1), (6, 112, 1), (6, 113, 1), (6, 114, 1), (6, 115, 1), (6, 117, 1), (7, 85, 1), (7, 87, 1), (7, 88, 1), (7, 89, 1), (7, 92, 1), (7, 93, 1), (7, 94, 1), (7, 99, 1), (7, 100, 1), (7, 101, 1), (7, 102, 1), (7, 105, 1), (7, 106, 1), (7, 107, 1), (7, 108, 1), (7, 109, 1), (7, 114, 1), (7, 115, 1), (7, 117, 1), (8, 85, 1), (8, 87, 1), (8, 88, 1), (8, 89, 1), (8, 92, 1), (8, 93, 1), (8, 94, 1), (8, 115, 1), (8, 117, 1), (8, 96, 0), (8, 97, 0), (8, 109, 0), (8, 114, 0), (9, 85, 1), (9, 88, 1), (9, 89, 1), (9, 92, 1), (9, 93, 1), (9, 94, 1), (9, 99, 1), (9, 100, 1), (9, 101, 1), (9, 102, 1), (9, 105, 1), (9, 106, 1), (9, 107, 1), (9, 108, 1), (9, 109, 1), (9, 114, 1), (9, 115, 1), (9, 117, 1), (9, 87, 0), (9, 96, 0), (9, 97, 0), (10, 31, 1), (10, 32, 1), (10, 42, 1), (10, 33, 1), (10, 34, 1), (10, 35, 1), (10, 36, 1), (10, 37, 1), (10, 38, 1), (10, 39, 1), (10, 40, 1), (10, 41, 1), (10, 43, 1), (11, 31, 1), (11, 32, 1), (11, 34, 1), (11, 35, 1), (11, 36, 1), (11, 37, 1), (11, 38, 1), (11, 39, 1), (11, 40, 1), (11, 41, 1), (11, 43, 1), (12, 31, 1), (12, 34, 1), (12, 35, 1), (12, 36, 1), (12, 40, 1), (13, 31, 1), (13, 32, 1), (13, 35, 1), (14, 1, 1), (14, 2, 1), (14, 3, 1), (14, 4, 1), (14, 5, 1), (14, 6, 1), (14, 7, 1), (14, 8, 1), (14, 9, 1), (14, 10, 1), (14, 11, 1), (14, 12, 1), (14, 13, 1), (14, 14, 1), (14, 15, 1), (14, 16, 1), (14, 17, 1), (14, 18, 1), (14, 19, 1), (14, 20, 1), (14, 21, 1), (14, 22, 1), (14, 23, 1), (14, 24, 1), (14, 25, 1), (14, 26, 1), (14, 27, 1), (14, 28, 1), (14, 29, 1), (14, 30, 1), (15, 1, 1), (15, 3, 1), (15, 4, 1), (15, 5, 1), (15, 6, 1), (15, 7, 1), (15, 8, 1), (15, 9, 1), (15, 11, 1), (15, 13, 1), (15, 14, 1), (15, 15, 1), (15, 17, 1), (15, 18, 1), (15, 19, 1), (15, 20, 1), (15, 21, 1), (15, 22, 1), (15, 23, 1), (15, 24, 1), (15, 25, 1), (15, 27, 1), (15, 29, 1), (15, 30, 1), (16, 1, 0), (17, 1, 1), (17, 7, 1), (17, 14, 1), (17, 19, 1), (17, 20, 1), (17, 23, 1), (17, 27, 1), (18, 1, 1), (18, 4, 1), (18, 7, 1), (18, 8, 1), (18, 9, 1), (18, 13, 1), (18, 14, 1), (18, 15, 1), (18, 17, 1), (18, 18, 1), (18, 19, 1), (18, 20, 1), (18, 21, 1), (18, 22, 1), (18, 23, 1), (18, 24, 1), (18, 25, 1), (18, 27, 1), (18, 29, 1), (19, 1, 1), (19, 7, 1), (19, 14, 1), (19, 19, 1), (19, 20, 1), (20, 1, 1), (20, 3, 1), (20, 4, 1), (20, 7, 1), (20, 8, 1), (20, 9, 1), (20, 13, 1), (20, 14, 1), (20, 17, 1), (20, 18, 1), (20, 19, 1), (20, 20, 1), (20, 21, 1), (20, 22, 1), (20, 23, 1), (20, 24, 1), (20, 25, 1), (20, 27, 1), (20, 29, 1), (20, 15, 0), (21, 1, 1), (21, 3, 1), (21, 4, 1), (21, 5, 1), (21, 6, 1), (21, 7, 1), (21, 8, 1), (21, 9, 1), (21, 11, 1), (21, 13, 1), (21, 14, 1), (21, 15, 1), (21, 16, 1), (21, 17, 1), (21, 18, 1), (21, 19, 1), (21, 20, 1), (21, 21, 1), (21, 22, 1), (21, 23, 1), (21, 24, 1), (21, 25, 1), (21, 27, 1), (21, 29, 1), (21, 30, 1), (22, 1, 1), (22, 4, 1), (22, 7, 1), (22, 8, 1), (22, 9, 1), (22, 13, 1), (22, 14, 1), (22, 15, 1), (22, 16, 1), (22, 17, 1), (22, 18, 1), (22, 19, 1), (22, 20, 1), (22, 21, 1), (22, 22, 1), (22, 23, 1), (22, 24, 1), (22, 25, 1), (22, 27, 1), (22, 29, 1), (1, 117, 1), (4, 117, 1), (10, 118, 1), (10, 119, 1), (11, 118, 1), (11, 119, 1), (5, 120, 1), (5, 121, 1), (5, 122, 1), (5, 123, 1), (6, 120, 1), (6, 121, 1), (6, 122, 1), (6, 123, 1); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_acl_users` -- CREATE TABLE IF NOT EXISTS `phpbb_acl_users` ( `user_id` mediumint(8) unsigned NOT NULL default '0', `forum_id` mediumint(8) unsigned NOT NULL default '0', `auth_option_id` mediumint(8) unsigned NOT NULL default '0', `auth_role_id` mediumint(8) unsigned NOT NULL default '0', `auth_setting` tinyint(2) NOT NULL default '0', KEY `user_id` (`user_id`), KEY `auth_option_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Daten für Tabelle `phpbb_acl_users` -- INSERT INTO `phpbb_acl_users` (`user_id`, `forum_id`, `auth_option_id`, `auth_role_id`, `auth_setting`) VALUES (2, 0, 0, 5, 0); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_attachments` -- CREATE TABLE IF NOT EXISTS `phpbb_attachments` ( `attach_id` mediumint(8) unsigned NOT NULL auto_increment, `post_msg_id` mediumint(8) unsigned NOT NULL default '0', `topic_id` mediumint(8) unsigned NOT NULL default '0', `in_message` tinyint(1) unsigned NOT NULL default '0', `poster_id` mediumint(8) unsigned NOT NULL default '0', `is_orphan` tinyint(1) unsigned NOT NULL default '1', `physical_filename` varchar(255) collate utf8_bin NOT NULL default '', `real_filename` varchar(255) collate utf8_bin NOT NULL default '', `download_count` mediumint(8) unsigned NOT NULL default '0', `attach_comment` text collate utf8_bin NOT NULL, `extension` varchar(100) collate utf8_bin NOT NULL default '', `mimetype` varchar(100) collate utf8_bin NOT NULL default '', `filesize` int(20) unsigned NOT NULL default '0', `filetime` int(11) unsigned NOT NULL default '0', `thumbnail` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`attach_id`), KEY `filetime` (`filetime`), KEY `post_msg_id` (`post_msg_id`), KEY `topic_id` (`topic_id`), KEY `poster_id` (`poster_id`), KEY `is_orphan` (`is_orphan`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ; -- -- Daten für Tabelle `phpbb_attachments` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_banlist` -- CREATE TABLE IF NOT EXISTS `phpbb_banlist` ( `ban_id` mediumint(8) unsigned NOT NULL auto_increment, `ban_userid` mediumint(8) unsigned NOT NULL default '0', `ban_ip` varchar(40) collate utf8_bin NOT NULL default '', `ban_email` varchar(100) collate utf8_bin NOT NULL default '', `ban_start` int(11) unsigned NOT NULL default '0', `ban_end` int(11) unsigned NOT NULL default '0', `ban_exclude` tinyint(1) unsigned NOT NULL default '0', `ban_reason` varchar(255) collate utf8_bin NOT NULL default '', `ban_give_reason` varchar(255) collate utf8_bin NOT NULL default '', PRIMARY KEY (`ban_id`), KEY `ban_end` (`ban_end`), KEY `ban_user` (`ban_userid`,`ban_exclude`), KEY `ban_email` (`ban_email`,`ban_exclude`), KEY `ban_ip` (`ban_ip`,`ban_exclude`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ; -- -- Daten für Tabelle `phpbb_banlist` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `phpbb_bbcodes` -- CREATE TABLE IF NOT EXISTS `phpbb_bbcodes` ( `bbcode_id` tinyint(3) NOT NULL default '0', `bbcode_tag` varchar(16) collate utf8_bin NOT NULL default '', `bbcode_helpline` varchar(255) collate utf8_bin NOT NULL default '', `display_on_posting` tinyint(1) unsigned NOT NULL default '0', `bbcode_match` text collate utf8_bin NOT NULL, `bbcode_tpl` mediumtext collate utf8_bin NOT NULL, `first_pass_match` mediumtext collate utf8_bin NOT NULL, `first_pass_replace` mediumtext collate utf8_bin NOT NULL, `second_pass_match` mediumtext collate utf8_bin NOT NULL, `second_pass_replace` mediumtext collate utf8_bin NOT NULL, PRIMARY KEY (`bbcode_id`), KEY `display_on_post` (`display_on_posting`) ) ENGINE=MyISAM DEFAULT CHARSE
-
Die letzte Zeile deiner Datei scheint nicht vollständig zu sein, da sie mitten im SQL abbricht:
) ENGINE=MyISAM DEFAULT CHARSE
Somit denke ich, dass die Backupdatei deiner Datenbank fehlerhaft ist.
Zum Vergleich meine Datei an dieser Stelle, die ich mal schnell gemacht habe:
ENGINE=MyISAM DEFAULT CHARSET=latin1
Beitrag zuletzt geändert: 1.12.2009 14:25:41 von karpfen -
Humm^^
Seltsam, mal sehen ob ich das behoben bekomme.
Kann die DB mit 86 Tabellen denn zu groß sein?
Ich meine ich hätte schon größere gehabt und da funzte das. -
Ich hatte seit ich Denken kann mit phpmyadmin so meine Probleme. Und das unabhänig vom Webspace. mysql Dumper war da besser, hab ich allerdings nicht allzuoft verwendet, weil ich eben nun schon länger mit Navicat rumhantiere. Natürlich könnte es an der Größe der Datei liegen, sprich der Datenmenge in der Datenbank.
-
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!
lima-city: Gratis werbefreier Webspace für deine eigene Homepage