reapir mysql table from php

Hi Steve,

you're coming home from the backyard. Try the front door. Why would
you want users(browser sessions) iniatiate the repair sequence? This
is usually done by a cron job. If this repair procedure should be
event driven you may want to put a database in between the cron job
and the client application. The application would check the integrity,
if a repair procedure is needed, the flag in database would be set.
Afterwards the only task for the cron-job would be checking the repair
flag and carrying out necessary operations, if required.

Best Regards,

Lucas


steve wrote in message ...
 > I have an on-going problem that my ".MYI" mysql files get corrupted.
 > I have written php trapping routine to report on the problem to
 > admin. My next step is to initiate "repair table" right after the
 > error is trapped.
 >
 > The problem is that then I would have multiple repair table commands
 > initiated from different browser sessions. How can I make sure that
 > only one "repair table" is running at a time.