How to get rid of an annoying row in MySQL?

Question

MySQL

Hi,
I have a mysql database which is innoDB and there is one row in the database that causes Mysqld to crash every time I try to access it. Does anyone know of a way I could remove this line? If I do a DELETE...
DELETE FROM table_name WHERE ID =
MySQL doesn't accept this either... any thoughts on how I could get rid of that annoying line?

Answer 1

Copy the data to a new database, at least line by line, even through mysqldump, the whole question is what else works at all.

Answer 2

Have you tried operations like REPAIR TABLE?

Answer 3

Using mysqlcheck command line via SSH, Telnet. Only VPS or certain host servers will have SSH Telnet access, but this is the best way to fix the corruption if you have access. If there is no access, then this www.oemailrecovery.com/ru/mysql_recovery.html can be another solution