Datenbank wiederherstellen

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 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:

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]am]CA�e ��#��L|�!>B]���B���Q������A�]��#���m�1

Wie war der Befehl? Hast Du eine Chance, das in der Kommandozeile zu machen?

Danke für Deine Antwort Sebastian, ich habe Dir gerade eine PM geschickt.
MfG Marcus von Köche-Nord.de

p.s. für weitere Antworten wäre ich dankbar, den genauen Befehl kenne ich nicht.

Ich würde dem unerfahrenen DB-Admin von der Kommandozeile abraten.
Kopiere dir mal den Adminer (ein PHP-Datenbanktool) auf deinen Webspace. Das ist eine einzelne PHP-Datei, die alles kann, was phpMyAdmin auch kann, nur hundertmal besser.

http://adminer.org/

Nach Anmeldung an deiner Datenbank gibt es oben links den Button Exportieren.

Damit erzeugst du ein SQL-File mit allen Daten und der Struktur, was du dann wiederum im Adminer auf den anderen Server übertragen kannst.

Obacht: Du musst vermutlich eine Kopie von Adminer auf beide Server machen, weil der externe Datenbankzugriff sicher verhindert wird, wenn dein Hoster kein völliger Idiot ist.