标签归档:Repair MySQL Table

BASH修复所有mysql库表

Bash Script to Repair ALL MySQL Tables for ALL Databases

This is something any server owner/maintainer should have to run and fix ALL MySQL databases, it’s not the quickest script, but theoretically it shouldn’t fail (like myisamchk does sometimes, if the MySQL Table errors are too big/weird/deep)

So basically we’ll provide you with two files: mysql_repair_db.sh (this file is from http://www.fagioli.biz/?q=mysql-databas … ash-script but with a bug fixed) and mysql_repair, the file you will need to execute to fix all tables in all databases, because mysql_repair_db.sh only fixes all tables for one database (it can be useful, so we didn’t want to mix the two files) 继续阅读