From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <koka@atvc.ru>
Date: Fri, 4 Mar 2005 17:54:30 +0300
From: Konstantin Klimchev <koka@atvc.ru>
To: community@altlinux.ru
Subject: Re: [Comm] =?KOI8-R?Q?=C2=C1=DA=C1_=CE=C5_=C4=C1=CD=D0=C9=D4=D3?=
	=?KOI8-R?Q?=D1_=D0=CF_cron'=D5?=
Message-ID: <20050304175430.2954d94e@localhost.localdomain>
In-Reply-To: <20050304143709.8789916540@pechkin.sputnikmedia.net>
References: <20050304143709.8789916540@pechkin.sputnikmedia.net>
X-Mailer: Sylpheed-Claws 0.9.12b (GTK+ 1.2.10; i386-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at phantom.intranet.atk
X-BeenThere: community@altlinux.ru
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: community@altlinux.ru
List-Id: Mailing list for ALT Linux users <community.altlinux.ru>
List-Unsubscribe: <https://lists.altlinux.ru/mailman/listinfo/community>,
	<mailto:community-request@altlinux.ru?subject=unsubscribe>
List-Archive: <http://lists.altlinux.ru/pipermail/community>
List-Post: <mailto:community@altlinux.ru>
List-Help: <mailto:community-request@altlinux.ru?subject=help>
List-Subscribe: <https://lists.altlinux.ru/mailman/listinfo/community>,
	<mailto:community-request@altlinux.ru?subject=subscribe>
X-List-Received-Date: Fri, 04 Mar 2005 14:54:32 -0000
Archived-At: <http://lore.altlinux.org/community/20050304175430.2954d94e@localhost.localdomain/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

On Fri,  4 Mar 2005 16:37:09 +0200
[pioneer] <pioneer@bigmir.net> wrote:

> Есть скрипт, который я запускаю по крону. Скрипт дампит
> MySQL базу.

А упростить, (у меня по-нагляднее):

#!/bin/bash
TGID="/var/local/backup/mysql/"
OF=$(date +%Y%m%d).sql

NAME="mysql"
mysqldump --opt --no-create-info --force $NAME | bzip2 >
$TGID$NAME-$OF.bz2

#for NAME in базы_через_пробел
#do
#    mysqldump --opt --force $NAME | bzip2 > $TGID$NAME-$OF.bz2
#done

if test -f /var/local/backup/databases.conf; then
    . /var/local/backup/databases.conf
fi

for NAME in $BASES
do
    echo $NAME
    mysqldump --opt --force $NAME > $TGID$NAME-$OF
    bzip2 $TGID$NAME-$OF
done

соответственно, в /var/local/backup/databases.conf
определена переменная $BASES с перечнем баз

-- 
Best Regards, Konstantin Klimchev 
(mailto:koka@atvc.ru    jabber:koka@jabber.atvc.ru)
ATK-Internet ISP, Arkhangelsk, Russia