repair or auto-repair

[jerryy]

I want to add a repair menu, which one is better:

a) mysqlcheck.exe -umydatab -pmypass --repair hrd1
b) mysqlcheck.exe -umydatab -pmypass --auto-repair hrd1

thanks for the help

regards,

Jerry

 

[scsi]

You are on the wrong website.

 

[gaiusgracchus]

The repair is just that -- it just does the repair of the tables.

But auto-repair does three things: check, optimize and repair.

 

[gaiusgracchus]

Actually, that is not entirely correct.
It does the repair automatically if it finds a problem when it checks. Optimize is specified separately.

The repair is done when you already know the table is bad and you are asking for a repair to occur.

auto-repair goes and checks and if it sees a repair is needed, it does it automatically.