reapir mysql table from php

Joined: Jan 06, 2004 Posts: 655

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.

External Since: Jan 19, 2004 Posts: 7

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 <UseLinkToEmail.TakeThisOut@dbForumz.com> wrote in message news:<414f45f2$1_2@alt.athenanews.com>...
> 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.