Seite 1 von 1

Datenbank wiederherstellen

Verfasst: 17.07.2016 22:09
von mpc1981
Hallo,
ich versuche immer wieder eine Datenbank auf einem kostenlosem Server mit
Dump zu installieren. Das Forum ist PhPbb (und weil die DB zu groß für PhPbb
ist mache ich das mit Dump. Die DB die ich auf http://kochrezepte.bplaced.net
insallieren will kommt von http://www.köche-Nord.de . Ich kriege immer die gleiche
Fehlermeldung von Dump (die ich unten rangehängt habe). Und ich habe das
Forum auch schon neu installiert und es funktioniert auch.

Könnt Ihr mir bitte helfen ?

MfG Marcus von Köche-Nord.de

Nach der Meldung "soll die DM 'information_schema' mit den Inhalten DB.sql.gz
wiederhergestellt werden ?" kommt folgende Fehlermeldung:

Code: Alles auswählen

Array
(
    [max_zeit] => 9
    [startzeit] => 1468785501
    [xtime] => 1468785500
    [fileEOF] => 
    [actual_table] => unbekannt
    [offset] => 77
    [aufruf] => 1
    [table_ready] => 0
    [part] => 0
    [do_it] => 
    [errors] => 0
    [notices] => 0
    [anzahl_eintraege] => 3288345
    [anzahl_tabellen] => 253
    [filename] => DB.sql.gz
    [actual_fieldcount] => 0
    [eintraege_ready] => 0
    [anzahl_zeilen] => 100
    [summe_eintraege] => 0
    [erweiterte_inserts] => 0
    [flag] => -1
    [EOB] => 
    [dump_encoding] => utf8
    [compressed] => 1
    [tables_to_restore] => Array
        (
            [0] => php_acl_groups
            [1] => php_acl_options
            [2] => php_acl_roles
            [3] => php_acl_roles_data
            [4] => php_acl_users
            [5] => php_attachments
            [6] => php_banlist
            [7] => php_bbcodes
            [8] => php_bookmarks
            [9] => php_bots
            [10] => php_config
            [11] => php_config_text
            [12] => php_confirm
            [13] => php_disallow
            [14] => php_drafts
            [15] => php_ext
            [16] => php_extension_groups
            [17] => php_extensions
            [18] => php_forums
            [19] => php_forums_access
            [20] => php_forums_track
            [21] => php_forums_watch
            [22] => php_groups
            [23] => php_icons
            [24] => php_lang
            [25] => php_log
            [26] => php_login_attempts
            [27] => php_migrations
            [28] => php_moderator_cache
            [29] => php_modules
            [30] => php_notification_types
            [31] => php_notifications
            [32] => php_oauth_accounts
            [33] => php_oauth_tokens
            [34] => php_poll_options
            [35] => php_poll_votes
            [36] => php_posts
            [37] => php_privmsgs
            [38] => php_privmsgs_folder
            [39] => php_privmsgs_rules
            [40] => php_privmsgs_to
            [41] => php_profile_fields
            [42] => php_profile_fields_data
            [43] => php_profile_fields_lang
            [44] => php_profile_lang
            [45] => php_ranks
            [46] => php_reports
            [47] => php_reports_reasons
            [48] => php_search_results
            [49] => php_search_wordlist
            [50] => php_search_wordmatch
            [51] => php_sessions
            [52] => php_sessions_keys
            [53] => php_sitelist
            [54] => php_smilies
            [55] => php_styles
            [56] => php_teampage
            [57] => php_topics
            [58] => php_topics_posted
            [59] => php_topics_track
            [60] => php_topics_watch
            [61] => php_user_group
            [62] => php_user_notifications
            [63] => php_users
            [64] => php_warnings
            [65] => php_words
            [66] => php_wwh
            [67] => php_zebra
            [68] => phpba_acl_groups
            [69] => phpba_acl_options
            [70] => phpba_acl_roles
            [71] => phpba_acl_roles_data
            [72] => phpba_acl_users
            [73] => phpba_attachments
            [74] => phpba_banlist
            [75] => phpba_bbcodes
            [76] => phpba_bookmarks
            [77] => phpba_bots
            [78] => phpba_config
            [79] => phpba_config_text
            [80] => phpba_confirm
            [81] => phpba_disallow
            [82] => phpba_drafts
            [83] => phpba_ext
            [84] => phpba_extension_groups
            [85] => phpba_extensions
            [86] => phpba_forums
            [87] => phpba_forums_access
            [88] => phpba_forums_track
            [89] => phpba_forums_watch
            [90] => phpba_groups
            [91] => phpba_icons
            [92] => phpba_lang
            [93] => phpba_log
            [94] => phpba_login_attempts
            [95] => phpba_migrations
            [96] => phpba_moderator_cache
            [97] => phpba_modules
            [98] => phpba_notification_types
            [99] => phpba_notifications
            [100] => phpba_oauth_accounts
            [101] => phpba_oauth_tokens
            [102] => phpba_poll_options
            [103] => phpba_poll_votes
            [104] => phpba_posts
            [105] => phpba_privmsgs
            [106] => phpba_privmsgs_folder
            [107] => phpba_privmsgs_rules
            [108] => phpba_privmsgs_to
            [109] => phpba_profile_fields
            [110] => phpba_profile_fields_data
            [111] => phpba_profile_fields_lang
            [112] => phpba_profile_lang
            [113] => phpba_ranks
            [114] => phpba_reports
            [115] => phpba_reports_reasons
            [116] => phpba_search_results
            [117] => phpba_search_wordlist
            [118] => phpba_search_wordmatch
            [119] => phpba_sessions
            [120] => phpba_sessions_keys
            [121] => phpba_sitelist
            [122] => phpba_smilies
            [123] => phpba_styles
            [124] => phpba_teampage
            [125] => phpba_topics
            [126] => phpba_topics_posted
            [127] => phpba_topics_track
            [128] => phpba_topics_watch
            [129] => phpba_user_group
            [130] => phpba_user_notifications
            [131] => phpba_users
            [132] => phpba_warnings
            [133] => phpba_words
            [134] => phpba_zebra
            [135] => phpbb_acl_groups
            [136] => phpbb_acl_options
            [137] => phpbb_acl_roles
            [138] => phpbb_acl_roles_data
            [139] => phpbb_acl_users
            [140] => phpbb_attachments
            [141] => phpbb_banlist
            [142] => phpbb_bbcodes
            [143] => phpbb_bookmarks
            [144] => phpbb_bots
            [145] => phpbb_config
            [146] => phpbb_config_text
            [147] => phpbb_confirm
            [148] => phpbb_disallow
            [149] => phpbb_drafts
            [150] => phpbb_ext
            [151] => phpbb_extension_groups
            [152] => phpbb_extensions
            [153] => phpbb_forums
            [154] => phpbb_forums_access
            [155] => phpbb_forums_track
            [156] => phpbb_forums_watch
            [157] => phpbb_groups
            [158] => phpbb_icons
            [159] => phpbb_lang
            [160] => phpbb_log
            [161] => phpbb_login_attempts
            [162] => phpbb_migrations
            [163] => phpbb_moderator_cache
            [164] => phpbb_modules
            [165] => phpbb_notification_types
            [166] => phpbb_notifications
            [167] => phpbb_oauth_accounts
            [168] => phpbb_oauth_tokens
            [169] => phpbb_poll_options
            [170] => phpbb_poll_votes
            [171] => phpbb_posts
            [172] => phpbb_privmsgs
            [173] => phpbb_privmsgs_folder
            [174] => phpbb_privmsgs_rules
            [175] => phpbb_privmsgs_to
            [176] => phpbb_profile_fields
            [177] => phpbb_profile_fields_data
            [178] => phpbb_profile_fields_lang
            [179] => phpbb_profile_lang
            [180] => phpbb_ranks
            [181] => phpbb_reports
            [182] => phpbb_reports_reasons
            [183] => phpbb_search_results
            [184] => phpbb_search_wordlist
            [185] => phpbb_search_wordmatch
            [186] => phpbb_sessions
            [187] => phpbb_sessions_keys
            [188] => phpbb_sitelist
            [189] => phpbb_smilies
            [190] => phpbb_styles
            [191] => phpbb_teampage
            [192] => phpbb_topics
            [193] => phpbb_topics_posted
            [194] => phpbb_topics_track
            [195] => phpbb_topics_watch
            [196] => phpbb_user_group
            [197] => phpbb_user_notifications
            [198] => phpbb_users
            [199] => phpbb_warnings
            [200] => phpbb_words
            [201] => phpbb_wwh
            [202] => phpbb_zebra
            [203] => phpbba_acl_groups
            [204] => phpbba_acl_options
            [205] => phpbba_acl_roles
            [206] => phpbba_acl_roles_data
            [207] => phpbba_acl_users
            [208] => phpbba_attachments
            [209] => phpbba_banlist
            [210] => phpbba_bbcodes
            [211] => phpbba_bookmarks
            [212] => phpbba_bots
            [213] => phpbba_config
            [214] => phpbba_config_text
            [215] => phpbba_confirm
            [216] => phpbba_disallow
            [217] => phpbba_drafts
            [218] => phpbba_ext
            [219] => phpbba_extension_groups
            [220] => phpbba_extensions
            [221] => phpbba_forums
            [222] => phpbba_forums_access
            [223] => phpbba_forums_track
            [224] => phpbba_forums_watch
            [225] => phpbba_groups
            [226] => phpbba_icons
            [227] => phpbba_lang
            [228] => phpbba_log
            [229] => phpbba_login_attempts
            [230] => phpbba_migrations
            [231] => phpbba_moderator_cache
            [232] => phpbba_modules
            [233] => phpbba_notification_types
            [234] => phpbba_notifications
            [235] => phpbba_oauth_accounts
            [236] => phpbba_oauth_tokens
            [237] => phpbba_poll_options
            [238] => phpbba_poll_votes
            [239] => phpbba_posts
            [240] => phpbba_privmsgs
            [241] => phpbba_privmsgs_folder
            [242] => phpbba_privmsgs_rules
            [243] => phpbba_privmsgs_to
            [244] => phpbba_profile_fields
            [245] => phpbba_profile_fields_data
            [246] => phpbba_profile_fields_lang
            [247] => phpbba_profile_lang
            [248] => phpbba_ranks
            [249] => phpbba_reports
            [250] => phpbba_reports_reasons
            [251] => phpbba_search_results
            [252] => phpbba_search_wordlist
        )

    [filehandle] => Resource id #7
    [tablelock] => 0
)

Sql: 
Erweiterte Inserts: 0
Unbekannter SQL-Befehl:: �ck�0L4�F�����5q�e3�����#q����Շ���$I����YGe,Z��[���k'i��/״� ��3���D�y�b�p{��}u�����'Y��T��c���58.'�m������a�N�b�� 

�-; >(�.�dM���j��:�(�x����C4���r=.6&��B`��(&:A]m]CA�	��#��L|�!>B]���B���Q������A�]��#���m�1

Re: Datenbank wiederherstellen

Verfasst: 18.07.2016 20:14
von Kirk
Hallo
Bist du so vorgegangen: KB:Umzug

Re: Datenbank wiederherstellen

Verfasst: 21.07.2016 18:17
von mpc1981
Danke Kirk.