How to repair a MySQL table without using phpMyAdmin?

mysql crash xampp repair
Alexar picture Alexar · Feb 19, 2010 · Viewed 9.7k times · Source

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 to start filling process again, but I even could not retrieve table structure.

How can I get data back? Or just structure?

(i run mysql under xampp/windows on a amd quad)

Answer

Mike Sherov picture Mike Sherov · Feb 19, 2010

PHPMyadmin tends to have problems when executing long queries. If it failed to do the repair table with a specific error message, please post it. If it just hung, you shoul try the repair by using the command line version of mysql, it's located in the bin directory of your mysql installation. 

mysql -u username -p
mysql> use dbname;
mysql> repair table tablename;

depending on the size of the table, this could take A while.

If that doesn't work, your next move is to use myisamchk if your table uses the MyISAM engine.

Related questions

Delete a Crashed Innodb table

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 …

Read More
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 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