#!/bin/sh
#
# @(#)    mysql-bu    backup the sql databases    carl@carltm.com
# copyright 2006, Carl T. Miller, All Rights Reserved

#Since this file needs to have the mysql admin's password, be
#sure it is owned by root or a virtual user who will run the
#backup.  Only that user will have read permissions.

chmod 500 $0
mkdir -p /var/lib/mysql-bu
rm -rf /var/lib/mysql-bu/*
cd /var/lib/mysql-bu
hostname=`hostname`
user=root
passwd=PassWorD

for db in `mysql -p$passwd -B -e "show databases;" | tail -n +2`
do
  mysqldump --opt -u $user -p$passwd $db > $hostname.$db.sql
done