phpMyAdmin + MySQL Problem

Dieses Thema im Forum "Webentwicklung" wurde erstellt von yamiyugi227, 3. Januar 2006 .

Schlagworte:
Status des Themas:
Es sind keine weiteren Antworten möglich.
  1. Diese Seite verwendet Cookies. Wenn du dich weiterhin auf dieser Seite aufhältst, akzeptierst du unseren Einsatz von Cookies. Weitere Informationen
  1. #1 3. Januar 2006
    Also, ich habe ein Board auf Server A, wobei Server A uuurlangsam ist, darum möchte ich das Board auf Server B packen. Ich habe es zuerst mal exportiert, dann kam ein Fehler, wegen der Versionskompatibilität. Da habe ich es MySQL 4 kompatibel exportiert, was auch funktioniert hat, allerdings habe ich es ohne Komprimierung exportiert. Ein Befehl, der seeehr lange ist, nämlich ein INSERT INTO war zu gross, um ihn auszuführen. Darum dachte ich, ich zippe den gZip komprimiert und führe ihn dann aus. Das funzt auch wunderbar, nur kommt nun folgender Fehler:

    Und der Code-Anfang sieht so aus:

    Code:
    INSERT INTO `bb1_templatepacks` ( `templatepackid` , `templatepackname` , `templatefolder` , `parentid` , `templatestructure` )
    VALUES ( 1, 'Future Blue', '', 0, 'a:582:{s:12:"access_error";s:1:"0";s:8:"addreply";s:1:"0";s:16:"addreply_postbit";s:1:"0";s:17:"arcade_gold_light";s:1:"0";s:25:"arcade_gold_light_anzeige";s:1:"0";s:24:"arcade_gold_light_footer";s:1:"0";s:23:"arcade_gold_light_games";s:1:"0";s:27:"arcade_gold_light_games_bit";s:1:"0";s:24:"arcade_gold_light_header";s:1:"0";s:24:"arcade_gold_light_letter";s:1:"0";s:29:"arcade_gold_light_letterscore";s:1:"0";s:32:"arcade_gold_light_letterselected";s:1:"0";s:31:"arcade_gold_light_lettersession";s:1:"0";s:20:"arcade_gold_light_no";s:1:"0";s:26:"arcade_gold_light_playgame";s:1:"0";s:28:"arcade_gold_light_scoreboard";s:1:"0";s:32:"arcade_gold_light_scoreboard_bit";s:1:"0";s:25:"arcade_gold_light_session";s:1:"0";s:28:"arcade_gold_light_sessionbit";s:1:"0";s:30:"arcade_gold_light_session_king";s:1:"0";s:30:"arcade_gold_light_session_more";s:1:"0";s:32:"arcade_gold_light_session_sieger";s:1:"0";s:33:"arcade_gold_light_session_sieger1";s:1:"0";s:33:"arcade_gold_light_session_sieger2";s:1:"0";s:33:"arcade_gold_light_session_sieger3";s:1:"0";s:33:"arcade_gold_light_session_sieger4";s:1:"0";s:27:"arcade_gold_light_spielende";s:1:"0";s:37:"arcade_gold_light_spielende_kommentar";s:1:"0";s:25:"arcade_gold_light_top5bit";s:1:"0";s:27:"arcade_gold_light_top5board";s:1:"0";s:25:"arcade_gold_light_userbit";s:1:"0";s:26:"arcade_gold_light_userbit2";s:1:"0";s:26:"arcade_gold_light_userbit3";s:1:"0";s:26:"arcade_gold_light_userbit4";s:1:"0";s:26:"arcade_gold_light_userbit5";s:1:"0";s:24:"arcade_gold_light_weiter";s:1:"0";s:13:"archive_board";s:1:"0";s:23:"archive_board_threadbit";s:1:"0";s:13:"archive_index";s:1:"0";s:22:"archive_index_boardbit";s:1:"0";s:20:"archive_index_catbit";s:1:"0";s:14:"archive_navbar";s:1:"0";s:14:"archive_thread";s:1:"0";s:22:"archive_thread_postbit";s:1:"0";s:14:"attachmentedit";s:1:"0";s:18:"attachmentedit_bit";s:1:"0";s:12:"avatar_flash";s:1:"0";s:12:"avatar_image";s:1:"0";s:16:"bandit_anleitung";s:1:"0";s:22:"bandit_anzeigeergebnis";s:1:"0";s:19:"bandit_anzeigestart";s:1:"0";s:18:"bandit_gewinntable";s:1:"0";s:23:"bandit_gewinntable1_bit";s:1:"0";s:12:"bandit_index";s:1:"0";s:11:"bandit_info";s:1:"0";s:15:"bandit_no_money";s:1:"0";s:17:"bandit_no_tipgeld";s:1:"0";s:11:"bandit_play";s:1:"0";s:12:"bandit_start";s:1:"0";s:15:"bandit_topliste";s:1:"0";s:18:"bandit_toplist_bit";s:1:"0";s:11:"bandit_wait";s:1:"0";s:4:"bank";s:1:"0";s:10:"bank_admin";s:1:"0";s:14:"bank_auszahlen";s:1:"0";s:14:"bank_einzahlen";s:1:"0";s:9:"bank_game";s:1:"0";s:9:"bank_spar";s:1:"0";s:14:"bbcode_buttons";s:1:"0";s:16:"bbcode_colorbits";s:1:"0";s:15:"bbcode_fontbits";s:1:"0";s:13:"bbcode_script";s:1:"0";s:15:"bbcode_sizebits";s:1:"0";s:16:"bbcode_smiliebit";s:1:"0";s:14:"bbcode_smilies";s:1:"0";s:22:"bbcode_smilies_getmore";s:1:"0";s:5:"board";s:1:"0";s:9:"boardjump";s:1:"0";s:9:"board_cat";s:1:"1";s:15:"board_daysprune";s:1:"0";s:16:"board_daysprune2";s:1:"0";s:18:"board_moderatorbit";s:1:"0";s:15:"board_newthread";s:1:"0";s:14:"board_password";s:1:"0";s:15:"board_sortfield";s:1:"0";s:15:"board_sortorder";s:1:"0";s:15:"board_threadbit";s:1:"0";s:26:"board_threadbit_multipages";s:1:"0";s:35:"board_threadbit_multipages_lastpage";s:1:"0";s:22:"board_threadbit_rating";s:1:"0";s:11:"burg_fehler";s:1:"0";s:13:"burg_fehler_1";s:1:"0";s:19:"burg_frage_mit_bild";s:1:"0";s:20:"burg_frage_ohne_bild";s:1:"0";s:9:"burg_game";s:1:"0";s:14:"burg_game_lose";s:1:"0";s:17:"burg_game_refresh";s:1:"0";s:13:"burg_game_win";s:1:"0";s:11:"burg_portal";s:1:"0";s:24:"burg_portal_bit_weristwo";s:1:"0";s:17:"calendar_addevent";s:1:"0";s:17:"calendar_birthday";s:1:"0";s:18:"calendar_birthdays";s:1:"0";s:16:"calendar_daybits";s:1:"0";s:18:"calendar_editevent";s:1:"0";s:14:"calendar_event";s:1:"0";s:17:"calendar_eventbit";s:1:"0";s:15:"calendar_events";s:1:"0";s:17:"calendar_monthbit";s:1:"0";s:13:"calendar_view";s:1:"0";s:22:"calendar_viewbirthdays";s:1:"0";s:18:"calendar_viewevent";s:1:"0";s:6:"cheats";s:1:"0";s:10:"cheats_add";s:1:"0";s:10:"cheats_bit";s:1:"0";s:12:"cheats_cheat";s:1:"0";s:11:"cheats_copy";s:1:"0";s:11:"cheats_edit";s:1:"0";s:21:"cheats_kategorien_bit";s:1:"0";s:21:"cheats_kommentare_bit";s:1:"0";s:20:"cheats_kommentar_add";s:1:"0";s:21:"cheats_kommentar_edit";s:1:"0";s:13:"cheats_search";s:1:"0";s:19:"cheats_searchresult";s:1:"0";s:23:"cheats_searchresult_bit";s:1:"0";s:11:"cheats_show";s:1:"0";s:15:"cheats_show_bit";s:1:"0";s:10:"codephptag";s:1:"0";s:7:"codetag";s:1:"0";s:3:"css";s:1:"0";s:8:"diebgame";s:1:"0";s:23:"diebgame_ausgeschlossen";s:1:"0";s:16:"diebgame_beklaut";s:1:"0";s:12:"diebgame_faq";s:1:"0";s:13:"diebgame_main";s:1:"0";s:12:"diebgame_off";s:1:"0";s:12:"dragonknight";s:1:"0";s:19:"dragonknight_babble";s:1:"0";s:24:"dragonknight_babbleframe";s:1:"0";s:18:"dragonknight_blank";s:1:"0";s:20:"dragonknight_buyitem";s:1:"0";s:19:"dragonknight_buymap";s:1:"0";s:22:"dragonknight_character";s:1:"0";s:17:"dragonknight_drop";s:1:"0";s:23:"dragonknight_fastspells";s:1:"0";s:18:"dragonknight_fight";s:1:"0";s:22:"dragonknight_functions";s:1:"0";s:19:"dragonknight_gobank";s:1:"0";s:18:"dragonknight_goinn";s:1:"0";s:17:"dragonknight_help";s:1:"0";s:23:"dragonknight_help_items";s:1:"0";s:24:"dragonknight_help_levels";s:1:"0";s:26:"dragonknight_help_monsters";s:1:"0";s:24:"dragonknight_help_spells";s:1:"0";s:20:"dragonknight_infotxt";s:1:"0";s:22:"dragonknight_inventory";s:1:"0";s:21:"dragonknight_location";s:1:"0";s:18:"dragonknight_login";s:1:"0";s:16:"dragonknight_map";s:1:"0";s:17:"dragonknight_news";s:1:"0";s:24:"dragonknight_oncharacter";s:1:"0";s:19:"dragonknight_online";s:1:"0";s:18:"dragonknight_towns";s:1:"0";s:20:"dragonknight_welcome";s:1:"0";s:26:"dragonknight_welcome_fight";s:1:"0";s:25:"dragonknight_welcome_info";s:1:"0";s:6:"editor";s:1:"0";s:13:"editor_switch";s:1:"0";s:8:"editpost";s:1:"0";s:12:"elfer_betrug";s:1:"0";s:12:"elfer_delete";s:1:"0";s:13:"elfer_einsatz";s:1:"0";s:18:"elfer_einsatz_eins";s:1:"0";s:20:"elfer_einsatz_form_1";s:1:"0";s:20:"elfer_einsatz_form_2";s:1:"0";s:20:"elfer_einsatz_form_3";s:1:"0";s:20:"elfer_einsatz_form_4";s:1:"0";s:13:"elfer_endgame";s:1:"0";s:15:"elfer_endgame_1";s:1:"0";s:10:"elfer_gast";s:1:"0";s:11:"elfer_haupt";s:1:"0";s:14:"elfer_nodelete";s:1:"0";s:12:"elfer_nogast";s:1:"0";s:16:"elfer_noguthaben";s:1:"0";s:11:"elfer_notor";s:1:"0";s:19:"elfer_schongespielt";s:1:"0";s:12:"elfer_selbst";s:1:"0";s:15:"elfer_startgame";s:1:"0";s:9:"elfer_tor";s:1:"0";s:9:"empfehlen";s:1:"0";s:5:"error";s:1:"0";s:3:"faq";s:1:"0";s:4:"faq1";s:1:"0";s:12:"faq1_rankbit";s:1:"0";s:4:"faq2";s:1:"0";s:4:"faq3";s:1:"0";s:10:"faq_bbcode";s:1:"0";s:18:"faq_bbcode_content";s:1:"0";s:16:"faq_bbcode_links";s:1:"0";s:15:"faq_showsmilies";s:1:"0";s:18:"faq_showsmiliesbit";s:1:"0";s:8:"finduser";s:1:"0";s:6:"footer";s:1:"1";s:8:"forgotpw";s:1:"0";s:8:"formmail";s:1:"0";s:9:"gefrostet";s:1:"0";s:10:"gefrostet2";s:1:"0";s:8:"guthaben";s:1:"0";s:11:"guthabentop";s:1:"0";s:15:"guthabentop_bit";s:1:"0";s:14:"guthabentop_pm";s:1:"0";s:12:"guthaben_bit";s:1:"0";s:14:"guthaben_error";s:1:"0";s:17:"guthaben_finduser";s:1:"0";s:18:"guthaben_shop_body";s:1:"0";s:21:"guthaben_wen_geworben";s:1:"0";s:25:"guthaben_wen_geworben_bit";s:1:"0";s:27:"guthaben_wen_geworben_ueber";s:1:"0";s:17:"guthaben_zr_error";s:1:"0";s:18:"guthaben_zr_error2";s:1:"0";s:17:"guthaben_zr_spiel";s:1:"0";s:18:"guthaben_zr_tippen";s:1:"0";s:10:"halloffame";s:1:"0";s:15:"halloffame_game";s:1:"0";s:8:"hang_end";s:1:"0";s:11:"hang_footer";s:1:"0";s:10:"hang_index";s:1:"0";s:11:"hang_insert";s:1:"0";s:10:"hang_intro";s:1:"0";s:9:"hang_mins";s:1:"0";s:7:"hang_ok";s:1:"0";s:9:"hang_sins";s:1:"0";s:10:"hang_start";s:1:"0";s:10:"hang_stats";s:1:"0";s:10:"hang_sword";s:1:"0";s:11:"hang_sword2";s:1:"0";s:11:"hang_thread";s:1:"0";s:12:"hang_thread2";s:1:"0";s:10:"hang_upic1";s:1:"0";s:10:"hang_upic2";s:1:"0";s:6:"header";s:1:"1";s:7:"header2";s:1:"0";s:11:"headinclude";s:1:"1";s:4:"home";s:1:"0";s:18:"homelastthreadsbit";s:1:"0";s:16:"homenewsboardbit";s:1:"0";s:16:"hometeamgroupbit";s:1:"0";s:15:"hometeamuserbit";s:1:"0";s:7:"imprint";s:1:"0";s:5:"index";s:1:"1";s:17:"index_birthdaybit";s:1:"0";s:14:"index_boardbit";s:1:"0";s:12:"index_catbit";s:1:"1";s:14:"index_eventbit";s:1:"0";s:18:"index_moderatorbit";s:1:"0";s:17:"index_subboardbit";s:1:"0";s:16:"index_useronline";s:1:"0";s:12:"konto_auszug";s:1:"0";s:16:"konto_auszug_bit";s:1:"0";s:16:"konto_auszug_del";s:1:"0";s:9:"konto_del";s:1:"0";s:11:"konto_error";s:1:"0";s:10:"konto_shop";s:1:"0";s:17:"konto_ueberweisen";s:1:"0";s:24:"konto_ueberweisung_error";s:1:"0";s:25:"konto_ueberweisung_error2";s:1:"0";s:26:"konto_ueberweisung_error_2";s:1:"0";s:25:"konto_ueberweisung_nouser";s:1:"0";s:21:"konto_ueberweisung_ok";s:1:"0";s:5:"login";s:1:"0";s:11:"lottozahlen";s:1:"0";s:18:"lotto_gewinner_bit";s:1:"0";s:13:"lotto_scheine";s:1:"0";s:17:"lotto_scheine_bit";s:1:"0";s:11:"lotto_stats";s:1:"0";s:11:"memberslist";s:1:"0";s:15:"memberslist_aim";s:1:"0";s:18:"memberslist_avatar";s:1:"0";s:20:"memberslist_birthday";s:1:"0";s:17:"memberslist_buddy";s:1:"0";s:17:"memberslist_email";s:1:"0";s:23:"memberslist_fieldheader";s:1:"0";s:20:"memberslist_formmail";s:1:"0";s:18:"memberslist_gender";s:1:"0";s:20:"memberslist_homepage";s:1:"0";s:15:"memberslist_icq";s:1:"0";s:24:"memberslist_lastactivity";s:1:"0";s:18:"memberslist_letter";s:1:"0";s:22:"memberslist_membersbit";s:1:"0";s:15:"memberslist_msn";s:1:"0";s:16:"memberslist_none";s:1:"0";s:17:"memberslist_order";s:1:"0";s:14:"memberslist_pm";s:1:"0";s:23:"memberslist_postsperday";s:1:"0";s:21:"memberslist_rankimage";s:1:"0";s:21:"memberslist_ranktitle";s:1:"0";s:19:"memberslist_regdate";s:1:"0";s:18:"memberslist_search";s:1:"0";s:18:"memberslist_sortby";s:1:"0";s:22:"memberslist_userfields";s:1:"0";s:21:"memberslist_userlevel";s:1:"0";s:20:"memberslist_username";s:1:"0";s:21:"memberslist_userposts";s:1:"0";s:20:"memberslist_usertext";s:1:"0";s:15:"memberslist_yim";s:1:"0";s:13:"memberssearch";s:1:"0";s:30:"memberssearch_morebit_checkbox";s:1:"0";s:26:"memberssearch_morebit_date";s:1:"0";s:33:"memberssearch_morebit_multiselect";s:1:"0";s:28:"memberssearch_morebit_select";s:1:"0";s:26:"memberssearch_morebit_text";s:1:"0";s:14:"modcp_announce";s:1:"0";s:13:"modcp_postbit";s:1:"0";s:14:"modcp_postbit2";s:1:"0";s:14:"modcp_post_del";s:1:"0";s:16:"modcp_thread_cut";s:1:"0";s:16:"modcp_thread_del";s:1:"0";s:17:"modcp_thread_edit";s:1:"0";s:27:"modcp_thread_edit_important";s:1:"0";s:18:"modcp_thread_merge";s:1:"0";s:17:"modcp_thread_move";s:1:"0";s:28:"modcp_thread_remove_redirect";s:1:"0";s:12:"navbar_board";s:1:"0";s:15:"navbar_boardend";s:1:"0";s:5:"never";s:1:"0";s:9:"newthread";s:1:"0";s:18:"newthread_announce";s:1:"0";s:20:"newthread_attachment";s:1:"0";s:15:"newthread_error";s:1:"0";s:17:"newthread_iconbit";s:1:"0";s:15:"newthread_icons";s:1:"0";s:16:"newthread_prefix";s:1:"0";s:17:"newthread_preview";s:1:"0";s:18:"newthread_username";s:1:"0";s:7:"offline";s:1:"0";s:8:"pagelink";s:1:"0";s:16:"pagelink_current";s:1:"0";s:14:"pagelink_first";s:1:"0";s:13:"pagelink_last";s:1:"0";s:13:"pagelink_left";s:1:"0";s:18:"pagelink_nocurrent";s:1:"0";s:14:"pagelink_right";s:1:"0";s:10:"phpinclude";s:1:"0";s:7:"pmpopup";s:1:"0";s:12:"pmpopup_open";s:1:"0";s:13:"pmpopup_pmbit";s:1:"0";s:3:"pms";s:1:"1";s:7:"pms_bit";s:1:"1";s:20:"pms_bit_recipientbit";s:1:"0";s:12:"pms_deletepm";s:1:"0";s:13:"pms_folderbit";s:1:"0";s:18:"pms_moveto_options";s:1:"0";s:9:"pms_newpm";s:1:"0";s:11:"pms_printpm";s:1:"0";s:17:"pms_tracking_read";s:1:"1";s:20:"pms_tracking_readbit";s:1:"1";s:19:"pms_tracking_unread";s:1:"1";s:22:"pms_tracking_unreadbit";s:1:"1";s:10:"pms_viewpm";s:1:"0";s:17:"pms_viewpm_outbox";s:1:"0";s:23:"pms_viewpm_recipientbit";s:1:"0";s:5:"poker";s:1:"0";s:18:"poker_button_again";s:1:"0";s:17:"poker_button_deal";s:1:"0";s:19:"poker_button_double";s:1:"0";s:17:"poker_button_take";s:1:"0";s:10:"poker_info";s:1:"0";s:7:"polladd";s:1:"0";s:8:"polledit";s:1:"0";s:21:"polledit_reloadthread";s:1:"0";s:9:"pollstart";s:1:"0";s:21:"pollstart_give_parent";s:1:"0";s:13:"popup_smilies";s:1:"0";s:17:"popup_smiliesbits";s:1:"0";s:5:"print";s:1:"0";s:12:"print_navbar";s:1:"0";s:13:"print_postbit";s:1:"0";s:7:"profile";s:1:"0";s:19:"profile_bot_profile";s:1:"0";s:17:"profile_userfield";s:1:"0";s:8:"redirect";s:1:"0";s:8:"register";s:1:"0";s:19:"register_activation";s:1:"0";s:19:"register_disclaimer";s:1:"0";s:14:"register_error";s:1:"0";s:27:"register_userfield_checkbox";s:1:"0";s:23:"register_userfield_date";s:1:"0";s:30:"register_userfield_multiselect";s:1:"0";s:25:"register_userfield_select";s:1:"0";s:23:"register_userfield_text";s:1:"0";s:6:"report";s:1:"0";s:16:"rpg_action_error";s:1:"0";s:15:"rpg_action_ride";s:1:"0";s:11:"rpg_admincp";s:1:"0";s:20:"rpg_announcement_bit";s:1:"0";s:8:"rpg_bank";s:1:"0";s:17:"rpg_bank_guthaben";s:1:"0";s:13:"rpg_bank_loan";s:1:"0";s:20:"rpg_bank_transaction";s:1:"0";s:10:"rpg_battle";s:1:"0";s:14:"rpg_battle_bit";s:1:"0";s:21:"rpg_challenge_invalid";s:1:"0";s:17:"rpg_challenge_new";s:1:"0";s:12:"rpg_chat_bit";s:1:"0";s:13:"rpg_class_bit";s:1:"0";s:11:"rpg_cp-edit";s:1:"0";s:11:"rpg_cp-main";s:1:"0";s:10:"rpg_donate";s:1:"0";s:7:"rpg_faq";s:1:"0";s:10:"rpg_footer";s:1:"0";s:8:"rpg_gast";s:1:"0";s:18:"rpg_general_panel1";s:1:"0";s:18:"rpg_general_panel2";s:1:"0";s:10:"rpg_goduel";s:1:"0";s:10:"rpg_header";s:1:"0";s:15:"rpg_headinclude";s:1:"0";s:7:"rpg_inn";s:1:"0";s:13:"rpg_inventory";s:1:"0";s:18:"rpg_inventory_sell";s:1:"0";s:11:"rpg_levelup";s:1:"0";s:8:"rpg_main";s:1:"0";s:19:"rpg_members_profile";s:1:"0";s:16:"rpg_members_view";s:1:"0";s:26:"rpg_members_view_memberbit";s:1:"0";s:13:"rpg_navichain";s:1:"0";s:17:"rpg_new_bat_alert";s:1:"0";s:12:"rpg_p1attack";s:1:"0";s:11:"rpg_p1guard";s:1:"0";s:11:"rpg_p1uitem";s:1:"0";s:12:"rpg_p2attack";s:1:"0";s:11:"rpg_p2guard";s:1:"0";s:11:"rpg_p2uitem";s:1:"0";s:15:"rpg_player1wins";s:1:"0";s:15:"rpg_player2wins";s:1:"0";s:16:"rpg_records_main";s:1:"0";s:16:"rpg_records_view";s:1:"0";s:21:"rpg_record_battle_bit";s:1:"0";s:18:"rpg_register-class";s:1:"0";s:18:"rpg_shoperror_ride";s:1:"0";s:14:"rpg_shop_armor";s:1:"0";s:14:"rpg_shop_boots";s:1:"0";s:15:"rpg_shop_closed";s:1:"0";s:15:"rpg_shop_gloves";s:1:"0";s:16:"rpg_shop_helmets";s:1:"0";s:13:"rpg_shop_main";s:1:"0";s:12:"rpg_shop_map";s:1:"0";s:13:"rpg_shop_ride";s:1:"0";s:16:"rpg_shop_shields";s:1:"0";s:19:"rpg_shop_smallitems";s:1:"0";s:21:"rpg_shop_specialitems";s:1:"0";s:16:"rpg_shop_weapons";s:1:"0";s:14:"rpg_view_duels";s:1:"0";s:8:"rpg_wait";s:1:"0";s:6:"search";s:1:"0";s:11:"search_post";s:1:"0";s:14:"search_postbit";s:1:"0";s:13:"search_thread";s:1:"0";s:23:"security_system_blocked";s:1:"0";s:23:"security_system_cronjob";s:1:"0";s:21:"security_system_frame";s:1:"0";s:22:"security_system_income";s:1:"0";s:23:"security_system_related";s:1:"0";s:11:"shop_avatar";s:1:"0";s:10:"shop_error";s:1:"0";s:10:"shop_lotto";s:1:"0";s:16:"shop_lotto_error";s:1:"0";s:16:"shop_lotto_input";s:1:"0";s:14:"shop_lotto_off";s:1:"0";s:17:"shop_lotto_sendok";s:1:"0";s:14:"shop_poweruser";s:1:"0";s:20:"shop_poweruser_error";s:1:"0";s:19:"shop_poweruser_free";s:1:"0";s:18:"shop_poweruser_off";s:1:"0";s:24:"shop_poweruser_usererror";s:1:"0";s:14:"shop_userboard";s:1:"0";s:20:"shop_userboard_error";s:1:"0";s:18:"shop_userboard_new";s:1:"0";s:23:"shop_userboard_new_send";s:1:"0";s:18:"shop_userboard_off";s:1:"0";s:14:"shop_usertitle";s:1:"0";s:19:"shop_usertitle_free";s:1:"0";s:18:"shop_usertitle_off";s:1:"0";s:24:"shop_usertitle_usererror";s:1:"0";s:13:"snow_historie";s:1:"0";s:12:"snow_viewbit";s:1:"0";s:6:"sudoku";s:1:"0";s:16:"sudoku_highscore";s:1:"0";s:19:"sudoku_highscorebit";s:1:"0";s:15:"sudoku_mainhigh";s:1:"0";s:11:"sudoku_play";s:1:"0";s:18:"sudoku_playbuttons";s:1:"0";s:15:"sudoku_playinfo";s:1:"0";s:13:"suv_anleitung";s:1:"0";s:9:"suv_konto";s:1:"0";s:11:"suv_play_go";s:1:"0";s:13:"suv_play_play";s:1:"0";s:14:"suv_play_start";s:1:"0";s:9:"suv_start";s:1:"0";s:4:"team";s:1:"0";s:13:"team_groupbit";s:1:"0";s:12:"team_userbit";s:1:"0";s:18:"textchain_addreply";s:1:"0";s:18:"textchain_editpost";s:1:"0";s:6:"thread";s:1:"0";s:15:"thread_addreply";s:1:"0";s:20:"thread_attachmentbit";s:1:"0";s:25:"thread_attachmentbit_show";s:1:"0";s:31:"thread_attachmentbit_show_small";s:1:"0";s:35:"thread_attachmentbit_show_thumbnail";s:1:"0";s:18:"thread_attachments";s:1:"0";s:13:"thread_closed";s:1:"0";s:11:"thread_poll";s:1:"0";s:14:"thread_pollbit";s:1:"0";s:16:"thread_poll_edit";s:1:"0";s:18:"thread_poll_result";s:1:"0";s:21:"thread_poll_resultbit";s:1:"0";s:14:"thread_postbit";s:1:"0";s:18:"thread_postbitlist";s:1:"0";s:16:"thread_signature";s:1:"0";s:17:"thread_userfields";s:1:"0";s:13:"ueberfallstat";s:1:"0";s:17:"ueberfallstat_bit";s:1:"0";s:8:"usercbar";s:1:"0";s:6:"usercp";s:1:"0";s:20:"usercp_attachmentbit";s:1:"0";s:18:"usercp_attachments";s:1:"0";s:16:"usercp_avatarbit";s:1:"0";s:25:"usercp_avatarbit_guthaben";s:1:"0";s:19:"usercp_avatarbit_td";s:1:"0";s:19:"usercp_avatarbit_tr";s:1:"0";s:14:"usercp_avatars";s:1:"0";s:17:"usercp_buddy_list";s:1:"0";s:20:"usercp_buddy_listbit";s:1:"0";s:19:"usercp_email_change";s:1:"0";s:16:"usercp_favorites";s:1:"0";s:18:"usercp_ignore_list";s:1:"0";s:21:"usercp_ignore_listbit";s:1:"0";s:21:"usercp_options_change";s:1:"0";s:22:"usercp_password_change";s:1:"0";s:19:"usercp_profile_edit";s:1:"0";s:21:"usercp_signature_edit";s:1:"0";s:24:"usergroups_applyforgroup";s:1:"0";s:26:"usergroups_editapplication";s:1:"0";s:23:"usergroups_groupleaders";s:1:"0";s:38:"usergroups_groupleaders_applicationbit";s:1:"0";s:39:"usergroups_groupleaders_editapplication";s:1:"0";s:32:"usergroups_groupleaders_groupbit";s:1:"0";s:41:"usergroups_groupleaders_oldapplicationbit";s:1:"0";s:17:"usergroups_groups";s:1:"0";s:33:"usergroups_groups_appliedgroupbit";s:1:"0";s:33:"usergroups_groups_avaiblegroupbit";s:1:"0";s:32:"usergroups_groups_groupleaderbit";s:1:"0";s:29:"usergroups_groups_memberships";s:1:"0";s:25:"usergroups_groups_rankbit";s:1:"0";s:36:"usergroups_groups_useronlinegroupbit";s:1:"0";s:22:"usergroups_memberslist";s:1:"0";s:30:"usergroups_memberslist_userbit";s:1:"0";s:9:"userlevel";s:1:"0";s:16:"useronline_buddy";s:1:"0";s:10:"userrating";s:1:"0";s:16:"userrating_error";s:1:"0";s:17:"userrating_window";s:1:"0";s:6:"viewip";s:1:"0";s:9:"whoposted";s:1:"0";s:12:"whopostedbit";s:1:"0";s:12:"window_close";s:1:"0";s:11:"winterevent";s:1:"0";s:16:"winterevent_info";s:1:"0";s:3:"wiw";s:1:"0";s:9:"wiw_order";s:1:"0";s:10:"wiw_sortby";s:1:"0";s:11:"wiw_userbit";s:1:"0";s:8:"yw_stats";s:1:"0";s:24:"yw_statsbrowserplattform";s:1:"0";s:27:"yw_statsbrowserplattformbit";s:1:"0";s:23:"yw_statstoboardpostsbit";s:1:"0";s:25:"yw_statstoboardthreadsbit";s:1:"0";s:20:"yw_statstopposterbit";s:1:"0";s:20:"yw_statstopreplysbit";s:1:"0";s:26:"yw_statstopthreadposterbit";s:1:"0";s:19:"yw_statstopviewsbit";s:1:"0";s:18:"yw_statstopvotebit";s:1:"0";}' ) 
    Danke für jede Hilfe!

    MfG
     

  2. Anzeige
  3. #2 3. Januar 2006
    hm kann es sein das ein teiler der datenbank schon exportiert wurde ?

    denn

    Code:
    Duplicate entry '1' for key 1
    heißt ja das der eintrag 1 für schlüssel eins doppelt ist

    guck mal ob die die ganze datenbank nochmal leerst und versuch es dann nochmal :)
     
  4. #3 3. Januar 2006
    Ist ja klar, wenn man den code sieht^^

    Die templatepackid ist wohl das schlüssfeld und das MUSS eindeutig sein! Aber du machst ja immer ne 1 rein! Beim ersten mal geht das dann auch, aber beim 2.ma wirste ein problem bekommen!!!

    Weiße per phpmyadmin ma dem templatepackid-Eintrag "AutoWert" zu! und beim SQL befehl vorne die 1 einfach weg! Lass den eintrag dann quasi leer, weil soll ja autowert werden!
     

  5. Videos zum Thema
Die Seite wird geladen...
Similar Threads - phpMyAdmin MySQL Problem
  1. Antworten:
    0
    Aufrufe:
    325
  2. Antworten:
    3
    Aufrufe:
    718
  3. Antworten:
    3
    Aufrufe:
    1.401
  4. Antworten:
    10
    Aufrufe:
    1.150
  5. Antworten:
    4
    Aufrufe:
    1.164