I had a table with complicated columns, i started to fill it with a heavy data, during that, it crushed.
table reported as crushed 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)
If your table is in myISAM, myisamchk is the first tool to check. It resides in the /bin directory of your mySQL installation. Here is a list of its repair options.
It's wise to make a backup copy of your data directory before running myisamchk on it, just in case.
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.