Hello all,
I have one server, where electric power goes down time to time.
I have many databases in mysql, and some tables are corrupted.
Do you think it is good idea to write script and put it to cron, and
it should check if some table has error (MYSQL show status command?),
and if yes, it will repair it.
Just idea...
/brano
I think it would be a good idea to get a battery backup and prevent the
entire thing from going down.
On Fri, 23 Dec 2005, Ing. Branislav Gerzo wrote:
> Hello all,
>
> I have one server, where electric power goes down time to time.
> I have many databases in mysql, and some tables are corrupted.
> Do you think it is good idea to write script and put it to cron, and
> it should check if some table has error (MYSQL show status command?),
> and if yes, it will repair it.
>
> Just idea...
>
> /brano
>
>
--
Louis Gonzales
louis.gonzales@linuxlouis.net
http://www.linuxlouis.net
On 12/23/05, Ing. Branislav Gerzo <2ge@2ge.us> wrote:
> I have one server, where electric power goes down time to time.
> I have many databases in mysql, and some tables are corrupted.
> Do you think it is good idea to write script and put it to cron, and
> it should check if some table has error (MYSQL show status command?),
> and if yes, it will repair it.
You can use myisamchk:
http://dev.mysql.com/doc/refman/4.1/en/myisamchk.html
But it would be better to get a UPS.
dd
--
David Dooling