Delete a Crashed Innodb table

mysql crash innodb recovery
Sacx picture Sacx · Jul 10, 2010 · Viewed 17.7k times · Source

I cannot delete/drop a crashed Innodb table. I get the following error:

ERROR 1051 (42S02): Unknown table ‘accounts’

And if I want to create it I get the following error:

ERROR 1005 (HY000): Can’t create table ‘accounts’ (errno: -1)

This happens on my server after an accidental power failure.

Regards

Answer

Sacx picture Sacx · Feb 25, 2011

I also found this problem here http://www.randombugs.com/linux/crash-innodb-table.html and it seems just deleting ibdata file and restarting mysql can solve this. Anyway this is not truly a solution if you don't have any backup.

Related questions

MySQL Workbench crash on start on Windows

I`ve just installed my MySQL Workbench and it crashes on start and i really dont know what to do with it. Error codes from Event Log : Application Error Application that causes trobule: MySQLWorkbench.exe version: 6.2.3.12312, time signature: 0x541717ae …

Read More
How to repair a MySQL table without using phpMyAdmin?

I had a table with complicated columns, I started to fill it with a heavy data, during that, it crashed. table reported as crashed and need to be repaired. Repair Table in phpmyadmin could not repair it. Then I decided …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More