Mysql corrupt row

[ardjanzen]

Hi,
I have a mysql database which is innoDB and there is one row in the database which makes Mysqld crash every time I try to access it. Does anyone know of a way I could remove this row? If I do a DELETE...

DELETE FROM table_name WHERE id = <row_id>

MySQL crashes too... any thoughts on how I might get rid of it?

[cretaceous]

You should be able to do a myslq dump on the entire table (via phpMyAdmin or a script) then delete that row in a text editor, then re-upload.
There are also 'repair' table commands - but make sure you do a back up first.

[paknoukri]

Hello if you are not able to delete it from the command line of mysql database server then its possible that your database server has some issues to fix, if you delete row locally and upload it...I think still you will be facing error because of the mysql database server issues. can you paste the error log of your database server here please.