Hallo, Am Wed, 24 Mar 2004, Johannes Tyra schrieb:
DIR='/var/backup/sql' DATUM=`date '+%d-%m-%Y'` PASS='xxxxxxx' USER='root' DAYS=10
for db in `echo "show databases;" | mysql -u $USER --password=$PASS`
Koennte man evtl. durch 'echo .. | mysql .. | while read db' ersetzen.
do if [ "$db" != "Database" ] then printf "Sicherung für: $db "
if [ ! -d $DIR/$db ] then mkdir $DIR/$db fi
find $DIR/$db -mtime +$DAYS -exec ls -l {} \; find $DIR/$db -mtime +$DAYS -exec rm {} \;
mysqldump -u $USER --password=$PASS --opt $db > $DIR/$db/$db_$DATUM.sql
Besser vielleicht: test -d "${DIR}/${db}" || mkdir -p "${DIR}/${db}" find "${DIR}/${db}" -mtime "+$DAYS" -exec ls -l {} \; find "${DIR}/${db}" -mtime "+$DAYS" -exec rm {} \; mysqldump -u "$USER" --password="$PASS" --opt "$db" > "${DIR}/${db}/${db}_${DATUM}.sql" -dnh -- If you haven't got time to RTFM, you haven't got time to whine on this mailing list.