how to repair corrupt InnoDB database?
Hello,
when i run command "mysqlcheck -A | grep -v OK"
i see below corrupted database, how i can repair them?
because i am not able to repair them using "mysqlcheck -u root -p --auto-repair --optimize --all-databases"
[QUOTE]root@host [/home/]# mysqlcheck -A | grep -v OK
user1_5s9641sd8.jlao1_finder_tokens
note : The storage engine for the table doesn't support check
user1_5s9641sd8.jlao1_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user1_chat.event_triggers
Error : Table 'user1_chat.event_triggers' doesn't exist
status : Operation failed
user1_en.mod_w3esxi_logs
Error : Incorrect information in file: './user1_en/mod_w3esxi_logs.frm'
error : Corrupt
user1_en.tblsslorders
Error : Incorrect information in file: './user1_en/tblsslorders.frm'
error : Corrupt
user1_newlast.jlao1_finder_tokens
note : The storage engine for the table doesn't support check
user1_newlast.jlao1_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user2_apbfrm.cpsession
note : The storage engine for the table doesn't support check
user2_apbfrm.session
note : The storage engine for the table doesn't support check
user3_x5sd1e8s.maxlr_finder_tokens
note : The storage engine for the table doesn't support check
user3_x5sd1e8s.maxlr_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user4_PaNelsE6o_old.auditorreports
Error : Incorrect information in file: './user4_PaNelsE6o_old/auditorreports.frm'
error : Corrupt
auser4_PaNelsE6o_old.crawl_log
Error : Incorrect information in file: './user4_PaNelsE6o_old/crawl_log.frm'
error : Corrupt
user4_PaNelsE6o_old.texts
Error : Incorrect information in file: './user4_PaNelsE6o_old/texts.frm'
error : Corrupt
user5_1359.kqoek_finder_tokens
note : The storage engine for the table doesn't support check
user5_1359.kqoek_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user5_wp.wp_comments
Error : Incorrect information in file: './user5_wp/wp_comments.frm'
error : Corrupt
user5_wp.wp_links
Error : Incorrect information in file: './user5_wp/wp_links.frm'
error : Corrupt
user5_wp.wp_posts
Error : Incorrect information in file: './user5_wp/wp_posts.frm'
error : Corrupt
user5_wp.wp_users
Error : Incorrect information in file: './user5_wp/wp_users.frm'
error : Corrupt
user5_site.aaggregate_temp_1365151200
note : The storage engine for the table doesn't support check
user6_site.cpsession
note : The storage engine for the table doesn't support check
user6_site.session
note : The storage engine for the table doesn't support check
user6_deadteam.cpsession
note : The storage engine for the table doesn't support check
user7_deadteam.session
note : The storage engine for the table doesn't support check
user7_1st.i753i_finder_tokens
note : The storage engine for the table doesn't support check
user7_1st.i753i_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user8_db.c6l7j_finder_tokens
note : The storage engine for the table doesn't support check
user8_db.c6l7j_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user8_db.f3x1h_finder_tokens
note : The storage engine for the table doesn't support check
user8_db.f3x1h_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user9_21sd565s6as5d44.cnuie_finder_tokens
note : The storage engine for the table doesn't support check
user9_21sd565s6as5d44.cnuie_finder_tokens_aggregate
note : The storage engine for the table doesn't support check
user9_10.lastpopups
Error : Incorrect information in file: './user9_10/lastpopups.frm'
error : Corrupt
user9_10.pm
Error : Incorrect information in file: './user9_10/pm.frm'
error : Corrupt
user9_10.withdraw
Error : Incorrect information in file: './user9_10/withdraw.frm'
error : Corrupt
user9_sat.cpsession
note : The storage engine for the table doesn't support check
user9_sat.session
note : The storage engine for the table doesn't support check
user9_dhye5.wpdesina123_comments
Error : Incorrect information in file: './user9_dhye5/wpdesina123_comments.frm'
error : Corrupt
user9_dhye5.wpdesina123_links
Error : Incorrect information in file: './user9_dhye5/wpdesina123_links.frm'
error : Corrupt
user9_dhye5.wpdesina123_posts
Error : Incorrect information in file: './user9_dhye5/wpdesina123_posts.frm'
error : Corrupt
-
Hello :) The following document is a good place to start: [url=http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html]MySQL :: MySQL 5.5 Reference Manual :: 14.19 InnoDB Backup and Recovery Thank you. 0 -
if i does not repair them, it will be problem in future? 0 -
Yes, I suggest repairing the databases unless you don't plan on using those databases in the future. Thank you. 0
Please sign in to leave a comment.
Comments
3 comments