[MySQL]Upgrade

[FroZz97]

Hi liebe Community,

ich habe ein kleines Problem, ich habe mir einen Metin2 P-Server
aufgesetzt, wollte etwas in den Querry Table einfügen, dann bekam ich eine
Fehlermeldung, dass ich MySQL Upgraden soll,
dann habe ich mysql_upgrade in PuTTy eingegeben, dann kam diese Meldung:

 Spoiler

root@root258759:~ # mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
account.account OK
account.admin OK
account.ban_log OK
account.block_exception OK
account.gametime OK
account.gametimeip OK
account.gametimelog OK
account.iptocountry OK
account.is_items OK
account.is_kategorien OK
account.is_log OK
account.monarch OK
account.news OK
account.psc_log OK
account.send_notice OK
account.server_settings OK
account.tele_block OK
common.gmhost OK
common.gmlist OK
common.locale OK
common.locale_bug OK
common.spam_db OK
log.bootlog OK
log.change_name OK
log.command_log OK
log.cube OK
log.fish_log OK
log.gmhost OK
log.gmlist OK
log.goldlog OK
log.hack_crc_log OK
log.hack_log OK
log.hackshield_log OK
log.levellog OK
log.locale OK
log.locale_bug OK
log.log OK
log.loginlog OK
log.loginlog2 OK
log.money_log OK
log.pcbang_loginlog OK
log.quest_reward_log OK
log.refinelog OK
log.shout_log OK
log.speed_hack OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!
mysql.help_relation OK
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it!
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc
error : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
player.affect OK
player.affect_copy OK
player.affect_copy_copy OK
player.banword OK
player.card OK
player.change_empire OK
player.event071115_name OK
player.guild OK
player.guild_comment OK
player.guild_grade OK
player.guild_member OK
player.guild_war OK
player.guild_war_bet OK
player.guild_war_reservation OK
player.highscore OK
player.horse_name OK
player.item OK
player.item_attr OK
player.item_attr_rare OK
player.item_award OK
player.item_award_old OK
player.item_proto OK
player.item_proto_28 OK
player.item_proto_copy OK
player.item_proto_shop OK
player.land OK
player.lotto_list OK
player.marriage OK
player.messenger_list OK
player.mob_proto OK
player.mob_proto1 OK
player.monarch OK
player.monarch_candidacy OK
player.monarch_election OK
player.myshop_pricelist OK
player.object OK
player.object_proto OK
player.pcbang_ip OK
player.pet_name OK
player.player OK
player.player_deleted OK
player.player_deleted_bk OK
player.player_index OK
player.quest OK
player.refine_proto OK
player.safebox OK
player.shop OK
player.shop_class OK
player.shop_item OK
player.skill_proto OK
player.skill_proto_05 OK
player.skill_proto_copy OK
player.sms_pool OK
player.string OK

Repairing tables
mysql.help_category OK
mysql.help_keyword OK
mysql.help_topic OK
mysql.proc OK
Running 'mysql_fix_privilege_tables'...
ERROR 1034 (HY000) at line 635: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 636: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 671: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 676: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 690: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 694: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 758: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 759: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 761: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 762: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 770: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 771: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 773: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 774: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 793: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 794: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 796: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 797: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 805: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 806: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 808: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 809: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 814: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 815: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 817: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 818: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 824: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 825: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 841: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 996: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 997: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 1084: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 1085: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 1087: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 1088: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 1125: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 1154: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 1163: Incorrect key file for table 'host'; try to repair it
FATAL ERROR: Upgrade failed

Ich bitte euch um Hilfe!!!!

MFG FroZz97

[IceCreamx3]

Rechtsklick auf die beschädigte Tabelle in Navicat -> Repair

[FroZz97]

Bei DB komm aber dann Incorrect key file for table 'db'; try to repair it

[.Shōgun]

myisamchk --force /var/db/mysql/mysql/*.MYI

[FroZz97]

Originally Posted by .Shōgun

myisamchk --force /var/db/mysql/mysql/*.MYI

Ich habe diesen Befehl ausgeführt, doch leider erhalte ich weiterhin diesen Fehler "Incorrect key file for table 'db'; try to repair it" wie auch "Corrupt"

[Tuora]

Benutz eine neuere Navicat Version

[.Shōgun]

You can also try doing this:

rm -R /var/db/mysql/mysql/*
mysql_install_db

The user database will be reset to default though (root user with no password which can only be used from localhost)