#!/bin/csh
umask 066
set disk = `echo $bkppath\/$bkpdate\/mysql`  # default storage location
foreach i (`ls -1 /var/lib/mysql | grep -vF . | grep -v -e ibdata -e ib_logfile`)
  /usr/bin/mysqldump --allow-keywords $i > ${disk}/${i}.sql
end
exit