kostenloser Webspace werbefrei: lima-city


phpMyAdmin und MySQLDumper?

lima-cityForumProgrammiersprachenPHP, MySQL & .htaccess

  1. Autor dieses Themas

    midgardserben

    Kostenloser Webspace von midgardserben

    midgardserben hat kostenlosen Webspace.

    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
  2. Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

    lima-city: Gratis werbefreier Webspace für deine eigene Homepage

  3. 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.
  4. Autor dieses Themas

    midgardserben

    Kostenloser Webspace von midgardserben

    midgardserben hat kostenlosen Webspace.

    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.
  5. Kannst du vielleicht den Inhalt der Datei mal posten, insofern nicht irgendwas Geheimes drinsteht?
  6. Autor dieses Themas

    midgardserben

    Kostenloser Webspace von midgardserben

    midgardserben hat kostenlosen Webspace.

    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
  7. 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
  8. Autor dieses Themas

    midgardserben

    Kostenloser Webspace von midgardserben

    midgardserben hat kostenlosen Webspace.

    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.
  9. 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.
  10. Autor dieses Themas

    midgardserben

    Kostenloser Webspace von midgardserben

    midgardserben hat kostenlosen Webspace.

    OK, hab vielen Dank für deine Hilfe und erklärungen, bin nun um einiges schlauer. ;)

    Notiz an mich selbst:
    Danke-System für dieses Forum hier vorschlagen.
  11. Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

    lima-city: Gratis werbefreier Webspace für deine eigene Homepage

Dir gefällt dieses Thema?

Über lima-city

Login zum Webhosting ohne Werbung!