Problem in database

[morteza3245]

Hello
i see much of following line in my error log mysql: /var/lib/mysql/Host.domain.com.err

each day i have more than 500Line create like them.
Please help me, what is do ?

130925 5:47:56 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:48:01 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired
130925 5:48:03 [Note] Found 26651 of 26658 rows when repairing './database3_wp/wp_wfHits'
130925 5:50:11 [ERROR] /usr/sbin/mysqld: Table './database2_database2/td5ia_k2_items' is marked as crashed and should be repaired
130925 5:50:12 [ERROR] /usr/sbin/mysqld: Table './database2_database2/td5ia_k2_items' is marked as crashed and should be repaired
130925 5:50:12 [ERROR] /usr/sbin/mysqld: Table './database2_database2/td5ia_k2_items' is marked as crashed and should be repaired
130925 5:50:16 [Note] Found 20704 of 20708 rows when repairing './database2_database2/td5ia_k2_comments'
130925 5:59:52 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_antiflood' is marked as crashed and should be repaired
130925 5:59:52 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_session' is marked as crashed and should be repaired
130925 5:59:57 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_antiflood' is marked as crashed and should be repaired
130925 5:59:57 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_antiflood' is marked as crashed and should be repaired

Thanks for your Help.

 

[thinkbot]

from command line run
mysqlcheck -A --auto-repair

or from phpmyadmin repair those tables

 

[cPanelMichael]

Hello

Try repairing that database with a command such as:

mysqlcheck --repair database1_database1

Thank you.

 

[morteza3245]

i see following error in some of table:

note : The storage engine for the table doesn't support repair
database1_database1.td5ia_user_notes
note : The storage engine for the table doesn't support repair
database1_database1.td5ia_user_profiles
note : The storage engine for the table doesn't support repair
database1_database1.td5ia_user_usergroup_map
note : The storage engine for the table doesn't support repair
database1_database1.td5ia_usergroups
note : The storage engine for the table doesn't support repair
database1_database1.td5ia_users
note : The storage engine for the table doesn't support repair
database1_database1.td5ia_viewlevels
note : The storage engine for the table doesn't support repair

what do i do?

Thanks.

 

[thinkbot]

Those tables doesn't support that kind of repair, and probably don't need it, so ignore

 

[morteza3245]

i can transfer them to any type, for support repair?

Thanks.

 

[thinkbot]

no need, couse they are not damaged
they just don't support MyISAM type repair

 

[morteza3245]

Thanks, now i see following line:

130926 3:41:36 [ERROR] Got an error from thread_id=5369015, /home/rpmbuild/rpm-build/BUILD/mysql-5.5.32/mysql-5.5.32/storage/myisam/ha_myisam.cc:915
130926 3:41:36 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961728564 localhost root Checking table
CHECK TABLE `failures`
130926 3:41:54 [ERROR] Got an error from thread_id=5369015, /home/rpmbuild/rpm-build/BUILD/mysql-5.5.32/mysql-5.5.32/storage/myisam/ha_myisam.cc:915
130926 3:41:54 [ERROR] MySQL thread id 4946554, OS thread handle 0x7f6d7cc4f700, query id 961737449 localhost eximstats Waiting for table level lock
INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,host,ip,auth,localsender,spamscore) VALUES(FROM_UNIXTIME('1380148913'),'1VOxmK-003CCO-NA$
130926 3:41:54 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961732568 localhost root Checking table
CHECK TABLE `sends`
130926 3:42:06 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961742787 localhost root Checking table
CHECK TABLE `wp_commentmeta`

what i must do for this lines?

Thanks.

 

[cPanelMichael]

That indicates some of the tables referenced may be corrupted. Please review the following documentation on repairing corrupted tables in MySQL:

MySQL :: MySQL 5.5 Reference Manual :: 4.5.3 mysqlcheck

Thank you.