[sql.git] / sbin / repair

#!/bin/bash

E=`mysql -e 'show slave status;' | grep 'Incorrect key file' | head -n1 | cut -f20 | sed -r -e "s/^.*\/(.*)\.MYI.*Default database: '([^']*)'.*$/\2 \1/"`
DN=`echo $E | cut -d\  -f1`
TN=`echo $E | cut -d\  -f2`

if [ ! -z "$DN" ]; then
    if [ ! -z "$TN" ]; then
        mysql -e "repair table $TN; slave start;" $DN
    fi
fi
Commit	Line	Data
1cc0573f JP	1	#!/bin/bash
	2
	3	E=`mysql -e 'show slave status;' \| grep 'Incorrect key file' \| head -n1 \| cut -f20 \| sed -r -e "s/^.\/(.)\.MYI.Default database: '([^'])'.*$/\2 \1/"`
	4	DN=`echo $E \| cut -d\ -f1`
	5	TN=`echo $E \| cut -d\ -f2`
	6
	7	if [ ! -z "$DN" ]; then
	8	if [ ! -z "$TN" ]; then
	9	mysql -e "repair table $TN; slave start;" $DN
	10	fi
	11	fi