Solved Mysql corrupt row after updating OS

July 18, 2015 at 08:31:49
Specs: Windows 64
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?

See More: Mysql corrupt row after updating OS

Report •

July 19, 2015 at 01:11:39
Have you tried dumping and reloading the table?

Report •

July 19, 2015 at 10:26:11
✔ Best Answer
Restoring your MySQL Database or apply following powerful way

Above we backup the Tutorials database into tut_backup.sql file. To re-create the Tutorials database you should follow two steps:

• Create an appropriately named database on the target machine
• Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Report •

Related Solutions

Ask Question