question

vuorinenantti avatar image
vuorinenantti asked

corrupted innodb table crashing mysql

Hello guys, Running a simple query against corruption innodb table is crashing mysql. Table got corrupt during crash and truncate table command was in progressing when mysql crash. Now running a simple select * query is also crashing db. I dont know how to solve this complicated situation! Any ideas please...
mysqltablecrash
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@SQLShark avatar image @SQLShark commented ·
You might have more luck asking this question on a different website. While ASK has many users with a diverse set of skills, this site focuses on SQL Server not MySQL. http://stackoverflow.com/questions/tagged/mysql My response to your question would be can you restore from a back up?
0 Likes 0 ·

1 Answer

·
matleblanc avatar image
matleblanc answered
See the official page for some more info on this and a possible solution **Repair Toolbox for MySQL** [ http://www.sql.repairtoolbox.com/][1] There's also a bunch of free/commercial tools and different methods: [ http://www.filerepairforum.com/forum/databases/databases-aa/mysql/1395-%E2%80%8Bmysql-table-became-corrupted][2] [1]: http://www.sql.repairtoolbox.com/ [2]: http://www.filerepairforum.com/forum/databases/databases-aa/mysql/1395-%E2%80%8Bmysql-table-became-corrupted
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.