We've just moved our site over to a dedicated server. After a couple of days our code to record page access (ezwebstats) stopped working. After a fair bit of searching I discovered (with the help of phpMyAdmin) that a table was corrupted and not working. It was fixed with a simple command (I forget which at the mo).
Does anyone know of a free (or very cheap) utility (preferable php) that when run will report if any tables are corrupted and even better fix them?
Cheers.