mysql

MySQL check & repair script

Submitted by vladimir on Sat, 08/01/2009 - 11:17

linux
mysql
python

Recommended to run after every forced shutdown and periodically. Especially useful for large number of databases with MyISAM tables.

Requires: Python 2.x and MySQLdb (mysql python module)

#!/usr/bin/env python
 
#########################################
# Check all tables in all mysql databases
#
# Written by Vladimir Rusinov <vladimir@greenmice.info>, http://greenmice.info/
#
# Reqirements:
#   Python 2.x (tested with 2.4)
#   MySQLdb
 
#########################################
# Settings:
 
host="localhost"
username="root"
password=""