大理公司网站建设,网站开发背景400字,长春网站策划,网站网页设计心得开发人员反映猎豹有个功能报500错误#xff0c;让我查一下服务器上有没有做过什么调整#xff0c;额#xff0c;不会吧#xff0c;今天元旦啊#xff0c;谁会闲的蛋疼去调试服务器啊#xff0c;最后他们查到了和一个表有关的sql都执行不了#xff0c;那肯定是这个表损坏…开发人员反映猎豹有个功能报500错误让我查一下服务器上有没有做过什么调整额不会吧今天元旦啊谁会闲的蛋疼去调试服务器啊最后他们查到了和一个表有关的sql都执行不了那肯定是这个表损坏了查看数据库mysql use xx_syncReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql desc extension_1;ERROR 145 (HY000): Table ./xx_sync/extension_1 is marked as crashed and should be repairedmysql quitBye靠果然损坏了修复吧(myisamchk -r 数据库表MYI文件的路径)修复之前记得备份哦。[rootyw_db_yj xx_sync]# ./bmyisamchk -r db/xx_sync/extension_1.MYI- recovering (with sort) MyISAM-table db/xx_sync/extension_1.MYIData records: 101539- Fixing index 1myisamchk: warning: Duplicate key for record at 26664372 against record at 16160720- Fixing index 2Data records: 101538myisamchk: warning: 1 records have been removedPS如果这样还不行那就加-f 参数强制修复看一下是否修复ok[rootyw_db_yj xx_sync]# ./bin/mysql -uroot -p123456 --socklogs/mysql.sockWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 549105657Server version: 5.5.15-log Source distributionCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or \h for help. Type \c to clear the current input statement.mysql use xx_syncReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql desc extension_1;-------------------------------------------------------------| Field | Type | Null | Key | Default | Extra |-------------------------------------------------------------| id | int(11) | NO | PRI | NULL | auto_increment || passport | varchar(64) | YES | UNI | NULL | || content | longtext | NO | | NULL | || checkcode | varchar(45) | YES | | NULL | || createtime | int(11) | YES | | NULL | || updatetime | int(11) | YES | | NULL | |-------------------------------------------------------------6 rows in set (0.02 sec)mysql quitBye