auto repair script for mysql

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


.

Relevant Pages

  • Re: migrating my lenny install from 32-bit to 64-bit?
    ... databases on the new system. ... i have the freedom to shut down the mysql server after hours. ... But one thing you might consider with the db migration, ...
    (Debian-User)
  • Re: MySQL permission
    ... I gather this does the initial setup, though not the setting of root ... > on my MySQL server, and have not had any problems on that score. ... <list of databases including mysql> ...
    (comp.os.linux.misc)
  • Re: migrating my lenny install from 32-bit to 64-bit?
    ... databases on the new system. ... i have the freedom to shut down the mysql server after hours. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: MySQL & FP
    ... Databases in SQL Server and MySQL are managed using specific ... For SQL Server you would write an application using ASP or asp.NET (or ... MySQL hosts normally supply a PHP application - phpMyAdmin. ... You will have to write your own scripts, or use the FrontPage Wizards, ...
    (microsoft.public.frontpage.programming)
  • Re: auto repair script for mysql
    ... I think it would be a good idea to get a battery backup and prevent the entire thing from going down. ... I have one server, where electric power goes down time to time. ... I have many databases in mysql, ...
    (perl.dbi.users)