>DBS="genldgr ap ar corp misc"
>DUMP=$HOME/archive/dump
>
>cd $DUMP
>
>DIR=`date | cut -d" " -f1`
>mkdir -p $DIR
>rm -f Today
>ln -sf $DIR Today
>cd $DIR
>for K in $DBS
>do
>TBLS=`mysql -N -e "show tables" $K`
>for I in $TBLS
>do
>mysql -e "repair table $I" $K
>mysqldu
On 10-Jul-01 Jason Ziegler wrote:
> I'd like to see some that check current tables for corruption before
> exporting, and then naming the exports by date...
>
>
DBS="genldgr ap ar corp misc"
DUMP=$HOME/archive/dump
cd $DUMP
DIR=`date | cut -d" " -f1`
mkdir -p $DIR
rm -f Today
ln -sf $DIR T
I'd like to see some that check current tables for corruption before
exporting, and then naming the exports by date...
On Tuesday, July 10, 2001, at 06:18 PM, Wyly Wade wrote:
> Any body got any good through nightly maintenance and back-up scripts?
>
>
> Wyly Wade
> Forefront Inc
> 1413 S.
