Error: mysqlselect * fromt_intro; ERROR145 (HY000): Table. imms_coret_introismarkedascrashedandshouldbere1_red solution: [root @ iZ232s4zbqvZ ~] # Myisamchk-c-rvarlibmysqlimms_coret_intro.MYI
ERROR: mysql select * from t_intro; ERROR 145 (HY000): Table './imms_core/t_intro' is marked as crashed and shoshould be rewritable red solution: [root @ iZ232s4zbqvZ ~] # Myisamchk-c-r/var/lib/mysql/imms_core/t_intro.MYI-recovering (with sort) MyIS
Error:
Mysql> select * from t_intro;
ERROR 145 (HY000): Table './imms_core/t_intro' is marked as crashed and shoshould be retried red
Solution:
[Root @ iZ232s4zbqvZ ~] # Myisamchk-c-r/var/lib/mysql/imms_core/t_intro.MYI
-Recovering (with sort) MyISAM-table '/var/lib/mysql/imms_core/t_intro.myi'
Data records 183
-Fixing index 1
Found block that points outside data file at 437808
[Root @ iZ232s4zbqvZ ~] #
========================================================== ============================================
Problem:
130619 17:10:15 [Note]/usr/libexec/mysqld: ready for connections.
Version: '5. 1.47 'socket:'/var/lib/mysql. sock 'port: 3306 Source distribution
130619 17:10:45 [ERROR]/usr/libexec/mysqld: Table './cacti/syslog_incoming' is marked as crashed and shoshould be retried red
Solution:
1. Go to phpmyadmin to manage mysql
2. Select your database on the left.
3. Check the 'syslog _ incoming' table in the error message on the right.
4. Scroll down the screen to the bottom. There is a drop-down menu (With selected :). Select "repair table"
After the modification, no data loss was found, and a database was quickly backed up to other places. Backup is still very important!
Using MySQL commands can also solve the following problems:
Find the bin/myisamchk tool in the mysql installation directory, and enter:
Myisamchk-c-r/var/lib/mysql/cacti/syslog_incoming.MYI
Then the myisamchk tool will help you restore the index of the data table.