Quote:
Originally Posted by halfpint
Im on the phpmyadmin
|
I was having issues with a table last week. It was taking so long to check or repair that phpmyadmin was timing out.
In the front screen of phpmyadmin you can look at the processes running. If you have made several attempts at the check/repair you probably have multiple threads out there waiting for each to complete.
If you do I would get rid of all but the active process.
Once that process finishes, what I did was wrote a quick little php script to do the check table and repair table if necessary. In the script, at the start I turned off the server timeout.
The check table in my case took 6 hours to run but with the server timeout suspended it eventually reported back to the browser when it was done.
Good Luck