From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <raorn@immo.ru>
Date: Fri, 4 Mar 2005 18:11:27 +0300
From: "Alexey I. Froloff" <raorn@immo.ru>
To: ALT Linux Community <community@altlinux.ru>
Subject: Re: [Comm] =?koi8-r?B?wsHawSDOxSDEwc3QydTT?=
	=?koi8-r?B?0SDQzyBjcm9uJ9U=?=
Message-ID: <20050304151127.GF971@immo.ru>
Mail-Followup-To: ALT Linux Community <community@altlinux.ru>
References: <20050304143709.8789916540@pechkin.sputnikmedia.net>
	<20050304175430.2954d94e@localhost.localdomain>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="NGIwU0kFl1Z1A3An"
Content-Disposition: inline
In-Reply-To: <20050304175430.2954d94e@localhost.localdomain>
User-Agent: Mutt/1.5.7+cvs20050205i
X-Virus-Scanned: by amavisd-new at immo.ru
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 15:11:29 -0000
Archived-At: <http://lore.altlinux.org/community/20050304151127.GF971@immo.ru/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>


--NGIwU0kFl1Z1A3An
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Konstantin Klimchev <koka@> [050304 17:55]:
> > =E5=D3=D4=D8 =D3=CB=D2=C9=D0=D4, =CB=CF=D4=CF=D2=D9=CA =D1 =DA=C1=D0=D5=
=D3=CB=C1=C0 =D0=CF =CB=D2=CF=CE=D5. =F3=CB=D2=C9=D0=D4 =C4=C1=CD=D0=C9=D4
> > MySQL =C2=C1=DA=D5.
> =E1 =D5=D0=D2=CF=D3=D4=C9=D4=D8, (=D5 =CD=C5=CE=D1 =D0=CF-=CE=C1=C7=CC=D1=
=C4=CE=C5=C5):

> =D3=CF=CF=D4=D7=C5=D4=D3=D4=D7=C5=CE=CE=CF, =D7 /var/local/backup/databas=
es.conf
> =CF=D0=D2=C5=C4=C5=CC=C5=CE=C1 =D0=C5=D2=C5=CD=C5=CE=CE=C1=D1 $BASES =D3 =
=D0=C5=D2=C5=DE=CE=C5=CD =C2=C1=DA
=FC=C8, =CD=CF=CC=CF=C4=A3=D6=D6=D6=D6... ;-)

#! /bin/sh

=2E /etc/backup.conf

timestamp=3D`date +%Y.%m.%d.%H.%M`

for h in $dbbackupdir/*; do
  host=3D"${h##*/}"
  if [ -d "$dbbackupdir/$host" ]; then
    for db in `/usr/bin/mysql -u =C0=DA=C5=D2 -p=D0=CF=D2=CF=CC=D8 -h "$hos=
t" -B -s -e 'show databases'`; do
      mkdir -p "$dbbackupdir/$host/$db"
      /usr/bin/mysqldump -u backup -pcgfcbntkm -h "$host" -q -a -e -Q --add=
-drop-table "$db" | gzip -9c > "$dbbackupdir/$host/$db/$timestamp.sql.gz"
    done             =20
  fi   =20
done
find "$dbbackupdir" -type f -and -mtime +9 -print0 | xargs -r0 rm -f --



--=20
Regards, Sir Raorn.
-------------------
=EE=C5 =CE=C1=C4=CF abisuite =D7=D9=CB=C9=C4=D9=D7=C1=D4=D8. =EF=CE =CE=CF=
=D2=CD=C1=CC=D8=CE=D9=CA =C9 =D1 =C9=CD _=D0=CF=CC=D8=DA=D5=C0=D3=D8_
		-- rider in devel@

--NGIwU0kFl1Z1A3An
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFCKHqfVqT7+fkT8woRAsJ2AKCe9/Py4z3kVy9fLUlSsKbp4bYTMgCgnydm
SFvWweE7lAf1f9Q4Xf42MP0=
=nJ1p
-----END PGP SIGNATURE-----

--NGIwU0kFl1Z1A3An--