All pastes #880707 Raw Edit

Stuff

public text v1 · immutable
#880707 ·published 2008-01-29 21:01 UTC
rendered paste body
#
#!/bin/sh
#
umask 066
#
disk="`echo $bkppath\/$bkpdate\/mysql`"  # default storage location
#disk="/root/test"  # test dir
#
for i in `ls -1 /var/lib/mysql | grep -vF . | grep -v -e ibdata -e ib_logfile`; do
#
  /usr/bin/mysqldump --allow-keywords $i > ${disk}/${i}.sql
#
done

#Need to drop the whitespace around the = and add double quotes for the sh variable