]>
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 |