sudo mysql

use nomedatabse;

mysqlcheck -A --auto-repair



from:
https://stackoverflow.com/questions/4582832/repair-all-tables-in-one-go