From brokenpoet.org wiki

This script repairs all databases on a server:

---

wget http://scripts.brokenpoet.org/fixalldbs.sh

---

#!/bin/bash
# mneir I was told

for db in `mysql -s -B -e "show databases"`;
do      
       for table in `mysql $db -s -B -e "show tables"`;
       do      
               mysql $db -e "repair table $table";
       done
done